This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. 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 We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI 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.

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

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 15 November 2023

In this blog

Setting conditional formatting
Adding text to the legend

Gradient legends

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?

Parts of this blog
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