I will show you the top five features in the latest update of Power BI.
In February 2019 the biggest change is with the custom visuals and it may cost you some money.
Stay tuned for that as we dive into our top 5 features.
What feature would you like to see in Power BI?
post that in the comments below so we can all vote for those and you can click here or down the description to
access the complete update playlist and catch up on all the Power BI monthly updates
Hey, I'm Avi Singh, Microsoft MVP and a best selling Power BI Author
and if you want to become a Power BI Pro, make sure to click "Subscribe"
and hit that bell so you're notified whenever I go live to answer your Power BI questions
Let's start a number 5 cross highlighting on a single point in line chart
So let's look over to our bar bi desktop model
Now of course cross filtering is one of the key features in power bi it
Just lets you, you know
It really have fun with your data just kind of explore it and column and bar chart
Are a classic way to go and of course the modern table and the matrix can cross filter as well
But the line chart were a step behind and it used to be that you could not click on a line chart to cross filter
Or cross highlight other elements, but that has changed with this update
now when you click on a line chart
You would notice that it does cross
Highlight or cross filter if you choose to the other element so you can see as as I click on this and click
On separate elements. Everything else is cross highlighting
So now line charts are in a way
Can behave similar to how bar charts or stacked bar charts behave as far as filtering goes number 4
Update default visual interaction to cross filter
Now you notice earlier when I was interacting with this graph and the default behavior is actually cross
Highlight, so what it does is when I click on this element, you can see how its highlighting so it keeps that you know
The original number but kind of highlights the number that's effective right now and you see it all across now
Sometimes this is not the idea of behavior
Now you can go to the format bar and go over here to edit interactions
We change that behavior
but sometimes the filtering is the
Default behavior that you want and now you can change that in one fell swoop by going to the options
so let's go over there file option settings and options and
Divvy, go and now I can go to my report settings
And this is the new option which changes the default visual interaction from cross highlighting to cross filtering
So I'm gonna check that option. And again, it's gonna take effect right away
And now the default action is cross filtering so notice carefully how this is different when I click on this
Notice that it didn't highlight it just changed the number it filtered this number to that
So again, depending on the graphs that you have in your report
This may be the behavior that you need now
I should point out that this changes the default behavior
But you can always override specific behavior for specific visuals
Using the Edit interactions box number three updates to the new filter frame and this is in preview
That means you would have to go to your options to turn on the Spree view feature
But the filter pane has been a pretty amazing feature now
I've always said before the filter pane was introduced that
The filters any filters that you may introduce in this pane over on this side how long you try that again?
Any filter pane that you would introduce over on this side. I consider that to be built for authors
This is just too clunky and it doesn't quite look great. But the filter pane on the other hand. Oh my god
It's a thing of beauty, right? So before that, I don't have much choice if I wanted the end-user to
Interact or filter pretty much I had to go with a slicer but but slicers can again take a valuable real estate
but the filter pane is the answer to all of that now filter pane has been there for a long time and again,
It looks so beautiful and elegant that I wouldn't mind
in fact
I would welcome my users to kind of interact with that but the feature that's been each introduced here is a little more control
options of controlling the filtering pane and you can access that by
just not selecting any visual and then if you go over to
This tab, I think it's called formats. What does it call format? Okay, great
And then you have the filter pane where you have a lot of control now
I hadn't even quite paid attention to this, but you noticed that if a filter is selected
It is a different color and if nothing is selected, it is a different color. I think this may be the best use of
these specific formats
Although there are lots of options available
To change these to make the filters pop a little more then you play with that and see what I get
All right. I usually go light on colors that don't paint it hot pink or something, right?
Just just you know less the gentle touch is best. So all I did was I changed this to a slightly
Faded out. So a little
You know kind of less gray lighter lighter gray
And I added a border here and just I just wanted to point out again where you can change these settings
So here if you go to the filter cards
you can select the background color border and you can notice this is where I change the border and
You can switch that to say available and you can choose the colors and formats for that
And again just a small feature, but can add at really nice touch to your reports. Number two is the key
Influencers visual not this is a brand new
visual built into Microsoft and
And and and I saw the demo and I was so excited to play with this
So I I added a key influencer visual over here. And of course I went to my fields and said yep
Let me find out what is
Influencing my sales visual and it sales metric and it didn't work and it said measures and aggregates are not yet
Supported and analyzed and you click learn more you get more stuff. I'm like cool. I may be able to get around that
I'm just gonna not gonna use a measure. I'm gonna use the column itself
Now I'm kind of starting I started to get a feel that this is not a good idea. But let me try that
alright
so let me just replace the sales with the sales amount call him and
It gave me another warning that hey this has more than 10 unique of values
So, well finally I did click learn more and if this works best with what they call a categorical data
So let's say you have your customers organizing a tear or in the demo
They showed like n sat or you know, sorry influence rating something like high medium low or something like that. One two, seven
So if you have a categorical feel in there
This is what this visual is for now. So you can you can see that it can you know it
can tell you basically
When you select a categorical field it can tell you exactly what is influencing that
Now, why would I rank? It's so high even though I kind of struggle to use it
It didn't quite work the way I imagined because I think this underlines
underlies what is one of the key strengths of Microsoft and you've seen that and all are so many different features, which is
not just this but
natural language QA and all of these features which are AI driven and certainly Microsoft you can see is
Boldly moving in this direction and we're gonna see more and more of that
So this is number two on my list not just for what it delivers now
But what you know the way it's a sign of things to come
So guys watch out and stay tuned for what power bi team keeps delivering in the future updates. Woohoo
So number one is a doozy my friend so far bi has enabled
additional purchase options for custom visuals now the custom visuals
They have been free most of the time but they were some paid options
But they were really clunky and the app store the payment option wasn't kind of built in all that changes with this update
So, let me just walk you through and not how that's gonna work
But it's not just about that and not just about this feature
but what this means for the future of power bi so let's go in there and we're gonna go to our
Marketplace and look for one of the new visuals which has this paid feature. So in here, I'm gonna search for
Advanced donut chart that's one of the visuals
Bye-bye zoom, which has that and and notice that right here
You have this new text that may require additional purchase
Now, of course if you are used to apps on your phone, this shouldn't be surprising
I mean that model has been around for a long time
So here I can add this visual on my report
It imported it and I can click on it and I can start using it
So let me let me put a sale. This is a good visual. I've seen this in action a few times so great
So let's bring in our territory
groups and then country and and
Wait, let me try that again country. And right now it's working great
So North America, I can drew in I can drill out and that's great
But watch what happens as soon as I drop in a third level and it says hey, babe mode activated
So this is what I'm talking about and again
You can see it's kind of built in to this model and you see this in the visual options as well
You have this paid feature toggle and you can toggle it on or off
So let's say if you toggle it on you can see that all of these new features come in
Now my understanding of how this works is you can start a free trial and that will give you 30 days
So that way you can evaluate the paid functionality of any visual. But again this it's not about the feature
But what it means for the platform now for this, let me take you on a separate story offer
Some company you might know so Apple introduced the iPhone in 2007
Now the odd thing is when pundits and technical gurus analyzed the phone. The phone didn't really offer anything new
I mean
it was all the ideas and
Technology that was still out there and they just kind of put it together in the package
But of course the market now has spoken for it. They have done a trillion dollar
That's a thousand billion dollar in sales and my friends
The key feature. So again, they didn't have anything
radically new except one thing they had the
Marketplace and that's what was the differentiating feature and that kind of set their destiny
Now does that you know, so clearly you see Microsoft putting a lot of effort to building an amazing marketplace?
So I think it's a good sign for Microsoft. But of course we have to recognize that that's as a user
Well, there's some trade off now. I don't mind paying anytime for anything. That's kind of worth its value
And so if you're getting great use of a custom visual, that should be great, right?
None of us will mind paying for that but you know
There might be some people might feel a little sense of confusion about. Hey how many custom visuals are there?
Which one should I use which one is free? Which one is paid now?
I'll have to two piece of one piece of advice for you, which is custom visuals are great and visualization is awesome
But the real strength of power bi is under the hood
So if you're starting out in power bi or even if you're an intermediate
you're best served if you focus on the core concepts and
The my power bi tutorial and we're gonna link it up here in the description as well
It's a great way to get started on that and it focuses on the core concepts the query editor
Relationships Docs and more it's under the hood that matters
but again
I do want to hear from you about what you feel about this latest change and
Direction of Microsoft is going in with the new option for fade custom visuals
Leave a comment and let me know and if you want to catch up on all the latest Microsoft
Power bi desktop updates, then click the click the link in the corner on in the description to watch the complete updates playlist
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