I will show you the top 5 features in the latest updates of Power BI both April and May
2019 this time it was really hard to choose the number one it was almost a 3 way tie you
can see why as you watch this video to the end we show you what you really need to know
and we cover that in our series on Power BI updates you can access the complete playlist
by clicking at the corner in this video and catch up on all the recent Power BI updates
and if you're just getting started or keep getting stuck in Power BI then make
sure to check out our complete step by step Power BI tutorial which has been loved and
liked by thousands of viewers 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 see your Power BI questions let's dive
right in to our number 5 the filter pain improvements let's take a closer look now if you're a new
kid on the block you may not even remember that we do not have this beautiful Japan and
instead there was something in here which we had to drag feels into. Well that's a thing
of the past now we have this beautiful filter pain which blends with the report look feels
feels and looks part off that report element and this is where you can add filters for
your page. Or all pages or if you have a visual selected then you can add and drag it filters
on here as well for that specific visual. Are from controlling the existing Feelin adding
any filters do dat if you need the Microsoft Barbie I team has been doing a lot of work
to do to kinda chiseling shape and beautify this thing and some of the new things that
BC I'm using it again is that you can now re order so right now it's sorted alphabetically
but now you can have the ability to maybe drag and drop this category and put this right
next to it so sub category and put this right next to category and subcategory now of course
if you get in trouble you can always come back here and sort a dizzy again the other
thing that you have is you can also double click and rename this element now what hi
I would like to have is it as I was trying out this feature and noticed that as you hover
over it it gives you it gives you the actual field let's use I would like to be able to
control that and almost sure to to tip to users to give them more guidance on selecting
these field so I have actually submitted one of those ideas but again to come back here
and to recap what we have is filter pain is in itself it's beautiful new clean look which
blends with the report but now we have some of the new functionality in their ability
to reorder elements and ability rename now I'm gonna put a link in the description for
the idea that I suggested which is have 2 diff show when users however over a specific
filter in the fence pain just to provide them sometimes maybe more guidance number 4 is
the new capability to drill through across reports now drilled through has being a feature
in power BR for a long time and the way it works is let's say I have this customer report
which shows details of a specific customer and the way I can set this up as a drill through
is justified click somewhere on a blank area and the support and and notice here that it
say's added drilled through feels here and I can go to my field well and let's say go
to customer. And I want to drag over full name over here now once that is set this this
page is is now set up as a drill through page based on this fear that I just dragged in
and now anywhere else in this report if that field is being shown as it is being shown
in this case then users are going to have the ability to right click and access that
drilled through detail and once they do that whatever their dearest right clicking on safe
I'm right clicking on Nicole mera and that is going to be pre filtered in when they navigate
to that report so that is the regular jewel through capability the only thing that has
changed in here is in now you can turn dis Stargell on and have this work across different
reports in work spaces which of course makes it really truly incredible so again right
now I was showing you June 2 capability within the same report but now the second tab this
can live in a different report as long as the same workspace and you turn this toggle
on a cross support across support drilled through is going to work just the way I show
you here now what do we have a link to a Microsoft video with more to step by step details on
setting up to cross the border through if you just need a little more help than what
I showed you here. Number 3 is to disable auto table what in the one of my talking about
not if you are a rank newbie in power be I it then you're probably living with stuff
like this now this is the automatic date hierarchy that Barbie I create not any self respecting
power be I the user knows that that's not the way to go and the right thing to do is
create your own calendar table and why settle for any average Joe calendar table my friend
when you can have the ultimate calendar table and this is yours to have frankly this is
one of my most popular videos which you can get here if you click in that corner or the
link in the description and what this gives you is gives you complete control over how
your calendar table behaves and not just that this has a lot of functionality month to date
year to date current month offset a lot of these tricks which make your life a whole
lot easier to go ahead and grab that and that's the ultimate counter table now again as I
said any any user who is not a rank newbie was just taken his first new steps you soon
realize that as soon as long as you have one day table in your data model which AB which
is every model that I've worked with so far then you need to carry a separate calendar
table and you should not use the built in date Harkey whatever that is so the good news
now is that that used to be really annoying for somebody who had a calendar table but
now you can turn that off at a global level yes indeed cause for celebration so you can
turn that off at a global level but this doesn't this only activates it for new files so if
you have any old files an old models which keep creating that data here I keep even though
you added the ultimate calendar table then you have to go back and change it on a file
by file settings for your old files so my friends this is one of those things which
is a small step for Barbie I some minor my. In a setting change but I believe that this
is a giant leap for mankind and that's why I was almost tempted to put it number one
but this time there was quite a bit of competition so let's look at our top 2. Number 2 this
is a big one and again this you know I'd really struggled this almost in any other month this
would have been number one by far let's look at a performance analyzer pains you access
the performance analyzer pain by going to the view menu and and checking this performance
analyzer box again kind of you many check performance analyzer in this opens up this
panel on the side and I pretty much in her is that right when you strip first open it
pretty much the only thing to do is to start recording but once you start recording well
this is the kind of stuff you can do you can you can click refresh visuals and what this
is going to do is refreshed all the visuals on this and you gonna get an extensive report
of exactly which element took how long and I believe you can sort it are well maybe you
can certainly look at the Hyatt the elements that took a long time and then you can click
details and see exactly what took so long with the dax query was the visual display
and sometimes there's as other bucket now of course if you hover over it it does give
you more details and other bucket can also be when things are just cued up should maybe
this ritual was just the last one to be rendered and this was just waiting for the other visuals
but again you see that there's so much rich information so now I'm gonna clear it and
start over and you can go visual by visual so I can go with this visual and I can see
I just want to focus in on this visual and and just focus on that single one and look
at the details now there are a lot of cool things here you can copy query look at the
underlying dax it,nd that was issued in there maybe that would give you a clue in optimizing
it you can also export this data and the export file actually is even more rich detail Dan
what is being shown here so you can see how performance analyzer is just is mind blowing
feature I mean if you're a stock earlier would slow performing reports it was it was hard
to kind of really figure out. Narrow down to the specific elements maybe a tax measure
or maybe something else that was slowing report down but this just makes your life so much
easier so by now you must be thinking oh my god what in the world can't beat that well
what be that this time and grab a number one is not a feature put a sign of things to come
number one my friends is conditional formatting what well yes stick with me here using it
as I said it's not about the future it's about the sign of things to come so conditional
formatting is not immune we have seen this in the first time at least I remember seeing
it was in being able to set the data colors and you can see I've already done it for this
one and it's showing up as FX initially it was it was a color like if you were to go
to a different report and look at data colors notice that is just set to color but you can
instead of that which you can do is click on this dog bar right there these days 3 dots
here let's just boredom on what that is the condition formatting Inc so click on that
3 dots and you can choose the form a conditional formatting options again this is not new this
has being there but what's noon is this so earlier you could do this for colors but now
you can do this for your titles as well so if I go to title. And again if I click on
these 3 dots notice that I can add a conditional formatting how under the name almost doesn't
right basically what it's saying is that instead of hard coating my text here I would like
to specify a function which controls it now I do have to graduate with this thing this
is not discoverable at all like unless somebody really help your Hannah showed you how to
find it you would be like what went with where is it how do I do that so it's hard to find
and and I think it's not quite named right it's not conditional formatting what it's
really is that instead of using this hard core value I would like a function or a measure
he lied to specified and that's what's happening in here as well I'm using a function and F.
X. for that but now you can specify a title in this can be completely dynamic you have
a measure which specifies your title and one of the place where you can specify a function
is if you had a button and in that action box if you specified let's say a U. R. L.
so let's go in here so again I have a a button over here which you can add just by going
to the home tab and buttons from one of these and I discussed much look a bit but if you
went to the action tab as to what happens when somebody clicks that button you could
choose a web you are out and earlier you could hard coded somebody I don't know maybe you're
reporting system or something but now what you can do is you can generate use a measure
generate a custom U. R. L. which factors in the selected customer service Nicole narra
is selected and we know the customer ID you can create a U. R. L. which uses that and
bass is that in as a parameter and a lot of reporting systems can use that to again show
orders and again we're not to actually I should say reporting system but production systems
right so this might be your actual system what customers place orders and orders a track
or could be the invoicing system so we're not talking about power be I will talk about
linking to a. It's separate system but being able to bask in it you are parameters to that
so this feature you can see how powerful this can be but again as I was saying earlier this
is not number one for the functionality itself but because of the sign of the things that
there is to come by as far as I know the tableau has had this feature were different elements
off the visual of the visualization of being a you know beat color title and even other
things can be specified not by hard coded value but by a function and that is exactly
what Barbie I team is promising to bring us so slowly and slowly you seen the different
elements and at some point maybe. Probably not all but most of the elements you can control
that problematically by defining these measures or functions instead of hard coating that
and you can only imagine the kind of flexibility and power that gives you to create and control
your power be I reports so does with the top 5 features in this update make sure to check
out the complete monthly update highlights playlist in check out our step by step Barbie
editorial until next time power on my friend Hey keep watching more videos and deep learning
Barbie I but if you did enjoy this video I would love to hear from you so leave a comment
like subscribe all the good stuff power on my friends.