559 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Changes in the July 2020 update to Power BI Desktop
Part three of a six-part series of blogs
This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes.
If you've set conditional formatting, you can show this in a chart's legend:
You can do this for stacked and clustered bar and column charts, as well as for scatter charts.
You won't see your conditional formatting until you enable it:
With your chart selected, click on this symbol to change the default background colour.
For this example I've gone for diverging colours:
The results should be unpleasant - like a child's sweet perhaps?
This gives the following default legend:
Here we're displaying the legend at the top centre of the chart.
I'm normally not a fan of legend titles, but for gradient legends they're useful to show what's going on:
Here I've moved the legend to the right of the chart, and added a title.
Here are the legend properties for the above chart:
I've turned the legend title on, and have customised the legend name.
I'm sure the Legend Name is a new property too! Until recently this always defaulted to the field being displayed, didn't it?
|Parts of this blog|
25 Aytoun Street