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 four 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 Customisable slicer headers (this blog) 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 four 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
Customisable slicer headers (this blog)
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

Customisable slicer headers

The slicer header has always seemed to be to be pointless (visual titles look so much better), but with this change it is finally usable:

Here I've changed the default slicer header from showing the visual field names to showing the words Time periods.

To see how this works, first create a slicer:

A default hierarchical slicer, allowing anyone to filter by year, quarter and/or month.

You can now go to the Slicer header formatting card, and change how this appears:

You can type in different title text, or set the text to show the value of a measure (not shown further here).

For the example at the top of this page, I've also decided to show a summary of what was chosen:

The Show summary option includes the user's current choices in the title.

Taken together with the extra slicer header formatting options which have appeared, it's now sensible to use the slicer header rather than a visual title to display text above a slicer.

Parts of this blog
Changes in the July 2020 update to Power BI Desktop Using financial functions from Excel in Power BI Gradient legends Customisable slicer headers (this blog) Relative time filters Q + A updates