I will show you the top five features in the latest update of Power BI July
2019. Our number one feature is something that brings
Excel and Power BI closer together
so stick around for that and then you can decide if that's a good thing or not. 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're just getting started or keep getting stuck in Power BI
Make sure to check out our complete a 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 start at number five power apps visual is now certified
Woo-hoos of by any fans of power app out there can rejoice so Power BI
it can provide interactive or even right back capability to your Power BI reports and
Now with this visual certified not only can you use it with a lot more confidence?
But more importantly now this is gonna work in the scenarios where this might have left kind of a hole in your report
So if you are exporting it to PowerPoint
or you have a set up this report to be included in a subscription now that visual is going to be rendered in your
report
number four is percent support for conditional formatting that conditional formatting is one thing that has
Steadily improved with bar bi and we're all glad for that. So let's switch over to a report and take a look at that
So let me show you how the conditional formatting has been set up
so if you examine the conditional formatting
I've done the background color, and I've used this newly available
Value so I can say that hey anything that's over 50% color this this light
I'm gonna call it light shade of green now
The key thing to remember is that how is the percentage calculated? I would admit it threw me off a little bit first
I was confusing it with percentile. It is not what it is
It is is built based on the data range the range of the data the lowest value to the highest value
so in this case, the lowest value is $2 and the highest value is
5.7 million, so
50% of this is right in the middle of this range. So two point five two point eight
Five two million and you can see values greater than that are green and similarly you can see over here the same
Conditional formatting but now the data range is different
So it calculates the 50%
Based on the lowest value in the highest value and the same thing over here if you want to examine this file a little bit
Closer to see how it all works
Then you can get it at learn power bi comm slash down and the link is also included in the description below
Number three is an exciting new addition to or query editor
Now query editor remember is the kitchen off your power bi that's where you clean shape
Transform if you want to learn more about that, you can click in the corner and access my power bi tutorial
So, let's see this one in action. So for this I'm gonna go to my query editor
I'm going to launch it from by clicking edit queries, and I have already loaded a sample file
Which we're gonna use for this so let's switch over to this file
So in here it's kind of hard to see because well, let me just show you how this data looks like in notepad
So notepad. This is a
Monospaced font so you can see oops that these numbers are all kind of lined up at a specific
character position so we're gonna try to
you know split this column by that position so I'm gonna go back in the microwave sure and
here I'm gonna say right-click and
Split column by positions now. This is where I was blown away my friends so you
Know it's hard to kind of get excited in a recording when you're doing it for the second time
but the first time I saw this I'm like what the what so
what I was expecting was that I'm gonna have to go back to note bad and
let's see what's happening here yet and maybe
Turn on the status bar and then you know do some something like this and say, okay
This is column 11 and or move my cursor and try to figure out that how many characters is it actually?
but lo and behold
Barbie I
Automatically guessed it it is insane
So I want you to try it out with your data set which has this and see in how many cases barbie I gets it
Right. It may not get it right in all the cases
But in my case it
Absolutely correctly identified exactly where the position of these different column is. So 0 10 15 i'm gonna hit
Okay
And there I have it that column has been split based on the specific position
Remember that if you do something like this
you might also want to trim the column again using the kitchen of power bi so just go to
The text section and format and and trim to remove any empty spaces
number two is performance improvements when using relative date and drop-down slicers now, um,
I'm pretty liberally used slicers whenever I need to now. I know we have the glorious and amazing filter pane, which is pretty awesome
but still you might run into scenarios or you might end up creating reports which look like this which have a
rich set of
Slicers or maybe even relative date filters the one you see at the top and you know a whole bunch of these drop-down
slicers now what was happening earlier was that
Just like regular slicers barbie
I was running queries
Against this to see which one of these values were valid and should be available
Now what Barbie has done is that it's not going to run those queries at the start
So report load times should be much faster if you create reports like this
now
of course the trade-off is that the first time the user clicks on this may take a little bit to load because that's when the
Queries are run but overall a certainly a positive move and you can see how power bi team kind of keeps
Looking at these corners and angles to how to improve this product for us. So kudos to the power bi team
Are you excited about our number one feature?
Are you about this this idea this thought of bringing in blending together Excel and power bi well?
we're gonna get to that but before that just one more reminder that hey if you're getting started or
You keep getting stuck in power bi make sure to check out my power bi tutorial and the link is in the corner
so the number one feature my friends for for this update which brings together excel and power bi is
Icon sets are now available in bar bi for tables and matrix now
This is of course something that has been there in Excel for a long time and there were some hacks
Which I had done in the past and I've done videos
in the past about KPIs where we had used icon sets and I'm gonna link to that just just you know,
You can just go down the memory lane
But now you don't have to follow any of these hacks because these are now built-in to power bi let's take a look
so here if you have a simple table and what I'm gonna do is I'm going to expand my
Visualization pane and we're gonna go to variants in this case. Let's zoom in so we can take a better look
All right, so I'm zoomed in and here you can see that in conditional formatting
there's also an option for icons and
And and there it is. So, of course the rules the specific rules you can specify
Using anything you want percentage number or change it up as you want
So you always have all the flexibility that conditional formatting provides
The only thing new is this now this ability to choose
From these icon sets so you can see there are a lot of rich options. They're pretty similar to
Excel but it goes beyond that as well
There's also flexibility to define your own icon sets if you like
but we're gonna leave it nice and simple over here and just hit OK and
There we have it
icon sets in power bi now if you want to catch up on all the recent Barbie updates just click in the corner and
Access our complete update playlist and now until next time power on my friend
Hey keep watching more videos and deep 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