Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
550 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
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.
We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses. |
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 |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.