I will show you the top five features in the latest update of Power BI August
2019 and the number one featured this time. Let's just say I've been waiting around for it for a long time
So stick around for that and find out. If you want to catch up on all the recent
Power BI updates then at the end of this video
Just click in the corner and access our complete
update playlist and if you are just getting started or keep getting stuck in Power BI make sure to check out our complete
Step-by-step Power BI tutorial. I'm Avi Singh Microsoft MVP and best-selling Power BI author
And if you want to become a Power BI Pro, make sure to subscribe and click that bell
So you are notified whenever I go live to answer your Power BI questions.
Let's kick off our countdown with number five the option
in fact the category for Power Platform
Within get data. Let's take a look
So if you go to Power BI and click on the get data dialog box
You're going to notice that now we have a new category called Power Platform as you can see that right there
And if I click on that, you're gonna find a few options there
There is the power bi data set which will allow you to connect to make a live connection to a model publish to a power
Bi service, but then there are also options for power bi data flows and common data service
So not only does this make it more convenient to find it, but it's also a great reminder of the rich
Ecosystem that exists around power bi we're gonna cover number four and number three which are pretty close and related to each other
So we're gonna cover conditional formatting warnings and I can style picker for conditional formatting
so icon sets were introduced earlier and we have
seen this in an earlier video and if I were to dive in here you can look at
conditional formatting and if I
Well this I was using icons and this was already available now
What is new are these icon sets now? You you realize that this kind of makes it closer to Excel, which is good
I mean it was nice and easy to use in Excel and now we have these
I can set so you can see that I can quickly select maybe a
Different pattern and it's going to pre-populate now. You can always override that selectively in
Using these selection if you wanted to but this just gives you kind of a nice and quick and easy way to select a set
Of icons the next thing we're going to look at are the conditional formatting warnings
So this one we're using an icon set defined and conditional formatting
But you can also use a measure so I'm going to show you here that I have defined a measure
Which returns a specific color and I believe you can return hex codes as well to be really specific
But you can return call their names as well
So first of all, I'm just going to quickly make a change here to add that as maybe a background color
so I'm going to format the conditional formatting and I'm going to apply background color to the budget variable and
When that pops up, there we go. I'm gonna choose instead of a color scale
I'm gonna use a field value and this is where I can return a measure now. This gives me ultimate control over
What I want to use it for
Oops, I had a small error and their formula. So let's try that again
So I'm gonna go to budget and I'm gonna choose conditional formatting background colors and in here
I'm gonna select field value and now it should let me select the formula
which is great and I'm gonna hit OK and
Well, yeah, it's not very pretty but you get the idea
this measure is returning that color that is being used and you can see the kind of
Flexibility that this can give you of course, this is a simple example
For more on icon sets you can catch up on one of our earlier updates
I think this was covered in July, but what I want to show you here
is that what if there's some case in and the formula which is
Returning an invalid value or something. That doesn't apply. It's not a valid color
So that is what the new feature is and it's a handy little feature, right, you know with great power comes great responsibility. So the
Using measures for conditional formatting gives you great power
But you know what if you get it wrong?
And that's where this feature comes in and you see what's happening here that it lights up this warning
I can say hey, there's something wrong something that is not working. Right and that it is indeed extremely useful by the way
If you ever want to grab any of this file or really any file shown being shown in my videos
You can always go to the URL shown on the screen. Just learn Barbie on comm slash download
Oh, we're getting close and we're getting to some really good stuff grouping
visuals now
Of course the heart of Barbie eye is under the hood
But hey, once you have mastered that once you have mastered the model the DAX with the relationships, you know
You gotta make it shine on the visuals
And this is where this feature comes in and makes it really handy to work with the items
so again
think of it kind of like PowerPoint and sometimes it makes a lot of sense to group items together so that maybe you can set
Their properties together or scale them together or just move them together a copy pasted them together in this case
I have this set of cards and a background square which I would like to group together and it works very intuitively very
similar to PowerPoint
So what I'm gonna do is I'm just gonna hold down my control key and select
These multiple items and it's a little bit tricky to select the square in the back
Maybe I should have started without but now all for a selected and now I can just right-click anywhere and I can use this
Group option now. Once that is grouped. What you can do is if you turn on the
view
Selection pane option right there
then you can see on the side this group and how it has these different elements and
It's pretty cool. I'm bio saying is that you can also?
further nest groups within each other so I can click this and
Combine it with another group and it's going to be a group of groups
I'll let you kind of play around an experiment with that and again really intuitive to use once you click first
It's gonna select the group as you can see kind of right there
But then you can kind of hover over it and and and click on it and can select an item inside that as well
Allowing you to easily set the properties for whichever element that you want in the group
But again, it makes it really handy to kind of copy paste or move around grouped items together. Alright, we are
There at number one the one that I mentioned I've been waiting with googly eyes
but before that just one more reminder if it getting started or keep getting stuck in power bi then make sure to check out our
Complete step-by-step power bi tutorial. The number one feature for this update is the key
Influencers visual now this is nothing new. So you must be asking like oh, why are you covering this now?
because it has now that one feature that it was missing and that was a must have which is
Measures support let's take a look. So the key influence of visual is part of the built-in visuals right here
so I'm just going to add a blank visual here and kind of make it super big and
the key influence of visual the idea for this visual is that it lets you understand your data and
uses the strength of AI artificial intelligence the background and
Sometimes data analysis can be looking for a needle in a haystack and this can help you with that task?
so the idea here is that
You say hey
What do you what do you want to analyze and I just want you to slice and dice and check it based on
This feature explained by so let's dive in so what I'm gonna do is of course, I'm gonna look at my sales now
Of course you could add any measure here
It could be a complicated measure like customer gained or churned rate or anything like that
And of course right now it's not doing anything and what I need to do is I need to add
The fields that I want to try to explain it by and you can you know, just go to this and maybe add a few
From here and what I'm gonna do is actually switch over the next visual where I have already
Added based on a few different things. So let me just do this see if I can get it working
Well, it's sometimes it's not happy
Until you add enough level of detail. So I'm just going to switch to that one and the only difference there is
That as you can see if I select this visual that I added a whole bunch of fields in here now
These are product attributes. This over here is coming from customer in my data set and way down at the bottom
This is coming from the territory data set. Alright
So and it analyzes in slices and dices and I was playing around with it and what I read
Was that the model name and product name was maybe a little bit too much detail
So I'm gonna remove those and see what the visual does
Yeah, and this seemed more meaningful
So if we if we you know kind of look into there so the key infants are now saying I can analyze
Whether I want to focus on what factors cause the sales to increase or I have an option here
I can say hey what factors caused it to decrease? So let's just take a quick tour of this
So right now is saying that haze when categories bikes
Then the average of sales really increase and it's showing by that amount and you can see kind of the graph and so forth
And if I look at subcategory, so oh great. This is also
You know kind of factors into an increase and and you can see over here
What's the average with doubt mountain bikes which is pretty low and with mountain bikes, you know
It increases by about two thousand two thousand in this case
and of course as you go down the list and you have
All of these things which you can kind of examine and there's also so this is kind of one factor at a time
But sometimes you want like a cluster of factors and that's what this table segments does
So what it's it's saying is that I found a few
You know kind of related
Filters if you will which call which lead to high sales. So let's just look at that
So I'm just gonna click on one segment so segment five
so again, what I said was does this is combining multiple criteria together unlike the first
Section the key influences was just looking at one factor at a time
But this one is combining a few them together and saying hey if you you know
If you were selling bikes in US and specifically rode bikes boy, then your sales numbers really helped, right?
It's really a factor and again, you can click around and look at some of the other segments. Look at that
So it's saying if categories bikes marital status is single so single people who are not in Australia United States
You know, they apparently buy more bikes how to sale
it is higher for that so you can see how this is an incredibly powerful visual and
Certainly my favorite use of this might be to get me started on the deep dive analysis
maybe use this as a first stop and just
Get a key idea the data set and then dive in myself and trying to understand what's going on
And now it has the key feature and then I was waiting for earlier
There was no support for measures but with that high call is complete and this is number one at our charts
So that's it for this update
but if you want to catch up on all the recent Barbie updates
Make sure to click in the corner and access our complete update playlist until next time power on my friend
Hey keep watching more videos and keep learning power bi but if you did enjoy this video
I would love to hear from you. So leave a comment like subscribe
All the good stuff while we're on my friends