WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 8944 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

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.

  1. Changes in the July 2020 update to Power BI Desktop
  2. Using financial functions from Excel in Power BI
  3. Gradient legends
  4. Customisable slicer headers (this blog)
  5. Relative time filters
  6. 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:

Customised slicer header

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:

Default 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:

Slicer header title text

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:

Slicer summary

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.

  1. Changes in the July 2020 update to Power BI Desktop
  2. Using financial functions from Excel in Power BI
  3. Gradient legends
  4. Customisable slicer headers (this blog)
  5. Relative time filters
  6. Q + A updates
This blog has 0 threads Add post