560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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.
|Parts of this blog|
25 Aytoun Street