I will show you the top five features in the latest update of Power BI June 2019.
Now June is usually a big month for Power BI features and they didn't
disappoint this time either. The number one feature is going to make your life
and the life of all your report users a whole lot easier
if you like easy stick around. 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 the
complete update playlist and if you're 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 and
let's start at number five the updated pane design now if you bring up Power BI
it's gonna look quite a bit different so again the dark theme is gone and and
this one has a lighter theme and everything has been the approach here is
to get similar to the office ribbon and and that's a great idea because a lot of
users come to power bi using office using Excel so they would have to have
that sense of continuity now power bi team isn't just gonna stop
there they're gonna continue to kind of make progress on this now of course if
you look at office and if I were just to pop out a excel and I have quite an ugly
chart there but you realize that Excel is a few steps ahead of bar bi here so
here you can see we have contextual menu so if I have the access selected then I
see that option if I have a these headings selected that I and then I see
the format legend and of course if I have the chart title so right so we have
contextual menus and it has a search capability which you may not even have
have seen but it can be pretty useful and what this lets me do is is let's say
I'm trying to a search for something change access and it shows me options
like that now if you're like me then you probably have gotten lost in the myriads
of options that power bi offers so something like that when hell
and it's a really encouraging sign that Microsoft power bi team is just kind of
leveraging all the good work in the UI design that's already being done in
Excel and that's gonna be a big win for the end user which is awesome my friends
let's move on to number four which is the ability to now add visual level
filters for slicers now this is something that was kind of sorely missed
and and it felt kind of weird so with every other visual you had the
opportunity or option to add add filters specific to that visual but this was
missing four slicers now of course in the slicer a common complaint is you
know people don't want to see blank well that you can get rid off quite easily by
going over here and either changing to advanced field training removing blank
or just doing select all and then removing blank from here but besides
that and you can now let's say go in and I can go to my territories table and
maybe bring in the group filter and add it here and then filter the slicer to
maybe only show Europe and North America so that was number four let's move on to
number three the ability to connect to shared and certified data sets now
connecting to a single data set is not new in fact this has been in the system
for quite a while and this is one of the most powerful features in power bi this
ability to publish a data set and then have that be used as a single source of
truth for all of your reporting needs you can create multiple bi reports and
multiple Excel reports connected to that single data set now if you want more
information and something to show you step-by-step how the structure works
where you authorize and consume from a single data source then do check out my
power bi tutorial which covers this in quite a bit detail so while that
functionality isn't new what is new is this new concept of shared and certified
data sets so now when you go to power bi desktop and say get data connect to
power bi data set you might see some new icons there and yet
you can see here these some of these reports can be labeled as promoted or
certified so in a large organizations users may often have access to quite a
you know quite a lot of datasets so of course these this designation and help
them zero in into the more important ones all right well we're warming up
here we're at number two conditional formatting updates now again this is
something that we have seen it is not a new feature we have seen this in a prior
release but as promised Barbee i-team has released more functionality around
this and they have also promised that they will continue to do so now it all
started I think with this data colors and you could go into data colors and
instead of having this be hard-coded you could specify as you can see I've
specified a function or FX and when you do that by clicking on the ellipsis over
here and if you click on this this one is using a color scale but there are
other options available to me as well you can see rules and field values there
so it kind of started here but again power bi team is completely making this
functionality across a lot of other elements so one thing we had seen in the
last release was this action button and here you can see that the action the web
URL is a function and I'll just show to you really quick and I just connected it
to a Google search but if Jordan Turner is selected then it's gonna open a URL
which is dynamically fed using the selected customer so if I were to select
somebody else Janet Munoz if I click on this again you know so obviously you're
not going to connect to Google you're probably going to connect to one of your
other systems which opens that customer in maybe like a transaction system or
something like that but again for this release power bi team has gone further
and now you can change background color so in this case background color is
using an FX setting in here if I can find it
there you go background color so you can see and the other one is using data
color as an FX setting so if you look at data label but again that is the
direction that Microsoft team is moving we're giving you the ability to freely
you know kind of demise things based on a function which
can be a lot of different things it can be again color scales rules field values
and possibly other scenarios here and field values by the way is where you
control it with a measure and that as an exciting option so here you can see that
you know all of these settings if I select different things they
automatically change color and so maybe not a very pretty example but you see
the the power and strength of this and yeah so this this holds a lot of promise
are you almost ready for number one well we'll take a quick pit stop we have some
honorary mentions one is the new Dax comparison operator that gives you a
little more flexibility little more control when controlling things against
zero and blank values so that's in new Dax comparison operator and then we have
the performance analyzer pane which we saw in a previous update and again you
can click in the corner to catch all of the monthly updates and this has a new
sorting ability allowing you to zero in on stuff that needs your attention and
next for those who love using custom visuals then you have the ability you've
been to visualization pane so that you don't have to every time you start a new
report you don't have to add them again and again your favorite custom visuals
are always gonna be available to you in your visualization pane
one more shout-out to our tutorial so if you're just getting started or keep
getting stuck that's the way that's your ticket out so go check it out alright so
let's go and talk about our number one now this is one of those simple features
but life changing this is the visual header and kudos to probably a team for
listening to the power bi team power bi community and delivering on this so this
is something where once you start building reports and somewhat
complicated reports you often want to guide the user and you want to provide
them some help as they're using the support and to tell them that what it is
they're looking at so I'm just going to show you the feature and then show you
how it is turned on so here if you notice that this this visual has a
special icon are you ready do you see the question mark let me hover on this
and you'll see so as I hover on this now this is a custom text that I typed in
and just guiding them that hey just letting them know that
do have the ability to select customer name which they may not have known right
so I add that added that as as kind of a visual header tooltip and you can also
connect this to a report page tooltip and usually these are used now again
this is an existing feature which we have covered in a prior monthly update
so go catch up on all the monthly updates if you have no idea what report
page tooltip is about but usually we use when hovering over charts and stuff but
you can use that with this visual header as well and just for having fun I used
it for here so as you can see in here if I hover over this I used a picture in
there and of course you can build anything you want in this case it's a
static image but this can be a live image if you wanted to so it gives you a
lot of flexibility and this is where it makes your life really easy both as a
report author and for all the report users because now you can kind of guide
them and have this guided experience help always available to them when
they're looking at the visual and looking at your reports so that's a top
5 list my friends and it was certainly an exciting month again you can check
out the complete monthly update playlist by clicking in the corner 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