COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
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.

  1. Changes in the July 2020 update to Power BI Desktop
  2. Using financial functions from Excel in Power BI
  3. Gradient legends (this blog)
  4. Customisable slicer headers
  5. Relative time filters
  6. Q + A updates

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

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.

Gradient legends

If you've set conditional formatting, you can show this in a chart's legend:

Gradient legend example

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:

Conditional formatting

With your chart selected, click on this symbol to change the default background colour.

 

For this example I've gone for diverging colours:

Diverging colours

The results should be unpleasant - like a child's sweet perhaps?

This gives the following default legend:

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:

Legend title

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:

Legend properties

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?

This blog has 0 threads Add post