These are the top five features you must know about
in the latest Power BI Update of April 2020.
Now these features pack quite a punch our number five feature here is a user
interface tweak you're gonna love number
four will help you easily make all of your
reports have a consistent look number three is
something that's going to help you optimize your queries and help them run
faster and better number two is one of the most
highly requested improvements to conditional formatting
but number one is a mind-blowing feature which is truly going to put self-serve
into Self-Service BI and going to empower all of your
Power BI report users so let's get started with number five but hey I'm
being rude let me say hello 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. If you want to catch up on
all the recent power bi updates just click in the corner and access our
complete month by month playlist all right so
number five is a user interface tweak you're gonna love
and there are two of them actually one is the rectangular lasso select
and new visualization icons let me just show you so lasso select
works pretty much like in powerpoint where you can just drag your mouse
and and select the visuals around and of course once you have selected
then you can you know move them together and so forth so again kind of like a
powerpoint feel and looks pretty cool and the other one also brings
power bi closer to the office family in that the visualization
icons have been updated i like the new cool look let me know what you think
about it in the comments down below so those are your user interface updates
let's move on to number four and this is going to help you make all of your
reports have a consistent look and this feature
is the ability to do customized themes now this is a mind-blowing feature and
now it's in general availability so if you go into view menu you can see
this beautiful layout of all these themes you can just select and
change with a single mouse click but the key feature here is this one
about the ability to customize the current theme
really easily all you have to do is click this button
and you can change the colors you can change the text sizes there's a lot of
settings you can change and in the end if you like you can just
name your custom theme and just hit apply and save that as
your personal theme maybe uh matching with your company colors or things like
that so certainly a pretty cool feature here before we move on to our top three
a quick shout out to a number one ranked power bi tutorial
and if you're just getting started or keep getting stuck in power bi
but want to create beautiful dashboards then check it out
links are in the corner and down in the description below
so let's move on to our top three and the number three here here
is going to help you optimize your query and the number three update
is query diagnostics update so what is this about this is not a new feature but
it has some changes to give you a quick recap the query
diagnostics what it lets you do is it have it gives you these start
diagnostics and stop diagnostics button kind of starts
tracing on the back end so you can hit the start button and
click refresh on your model and it's going to trace all of the
queries that's going on all of the work that the query editor or the query
engine is doing the back end and and you know attract detailed
information on that now rest assured you don't have to look
at this table you can easily visualize it and look at it visually
just using power bi and figure out where the bottlenecks may
be or where are the steps where you may want to optimize your queries
now if you want to learn more we're going to put a link links to in the
description below to find more information about query
diagnostics now just a tip for the mobile users to see
the description just tap the video title uh youtube doesn't make
it easy on mobile users to see the description
all right so what's the feature for this update
is the diagnose step which gives you a little more control
about specific steps which you want to diagnose
and most importantly the diagnostic options which lets you control the
amount of detail that gets captured so you can decide
whether you want to capture aggregated data detail data performance counters
or not so that is our number three feature
moving on to number two and this was one of the most highly requested
improvements to conditional formatting and power bi team has delivered on this
take a look so before you could apply conditional formatting
lots of different styles background colors data bars and so forth but it
didn't apply to the totals which was
pretty embarrassing in a lot of cases and of the barbier team has heard you
loud and clear and now they have this option
to apply any uh conditional formatting to either values only values and totals
or totals only so it gives you a lot more control so earlier which look like
this can now look like this so that's a
number number two feature and are you ready for
the mind-blowing number one feature which is gonna put
self-serve into self-service bi and this feature
is the ability to personalize visuals now let's take a step
back and let's make sure we understand this layout so
you as an author are going to author the power vm model in power bi desktop but
at that point you're going to publish it to power powerbi.com
where lots and lots of users are going to consume it
if that does not make sense then go check out my tutorial
that i mentioned earlier so this is where
this feature really delivers it makes all of these consumers are going to
consume the report it gives them the ability to personalize
their visuals and truly have it be self-serve bi
so let's look at the scenario so let's say you as an author build this report
and it's a beautiful report and mostly everybody loves it
but there's some users maybe there's catherine who's saying you know what
i would like that visual to show me sales by occupation and group and then
there's jimmy who says you know what i want to see that but i want to see that
as a 100 stack chart and then there's carol
who wants to see a trend over time so you see
users might have different needs and if every time
they have to go back to the model of the report author
that can take up a lot of time and that is not really self-serve bi
with this features the users have the ability to personalize the visuals
as they want so this is what you need to do to
use it first you need to enable it this is a preview feature so go into previews
option and enable that and then you need to
turn it on in report settings but once you have
done that then users are going to have the ability to personalize their visuals
once they're published to power bi.com right so you publish the report there
and there on the frontendpowerbi.com users can
just go to your report and click the personalize button and
they have all of these options in there to really change the
layout change the fields and pretty much do whatever they want so
it gives them a lot of ability and once they've done that
they can save that as a personal bookmark and not just that
they can also make it the default view so that when they load it
their personalized view is the one that's loaded
by default how amazing is that so that's our number one feature which puts
self-serve into self-service bi hey leave us a comment let us know which new
feature was your favorite check out the videos that i mentioned in
this video by clicking in the corner or you can click here to keep watching
our next video now don't forget to subscribe as that
really helps support our channel and helps us put out great content until
next time power on