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
- 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 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.
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 (hierarchical slicers were introduced into Power BI last month, although you can use this new feature to change the title of normal slicers too).
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.
- 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