BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Changes in the July 2020 update to Power BI Desktop
- Using financial functions from Excel in Power BI
- Gradient legends (this blog)
- Customisable slicer headers
- Relative time filters
- Q + A updates
Posted by Andy Brown on 23 July 2020
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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.
Setting conditional formatting
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.
Adding text to the legend
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?