COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Changes for the June 2020 update of Power BI Desktop
Part two of a six-part series of blogs

This month's update doesn't include many changes - the biggest being probably the emergence of the hierarchical slicer from preview.

  1. Power BI June 2020 update - summary of new features
  2. Hierarchical slicers (this blog)
  3. Much-improved mobile report designer
  4. Individual dots on line charts
  5. Automatic refresh
  6. AI insights in Query Editor

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 28 June 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.

Hierarchical slicers

What happens when you want to choose by different levels of a hierarchy?

Hierarchical slicer

Here I've chosen King's Lynn and Lowestoft as towns in East Anglia, but I've also chosen the whole of the London region.

 

The answer?  Add more than one field into your slicer:

Slicer fields

This slicer is letting you choose by region AND town.

 

Customising the appearance of hierarchical slicers

You can choose from 3 sets of expand/collapse symbols in the Items card:

Possible icons sets

The three sets of icons on the drop-down list are Chevron, Plus/minus and CaretChevron is shown above, and the other two are shown below.

 

Here's what Plus/minus and Caret symbols look like:

Plus/minus symbols Caret symbols
Plus/minus Caret

Personally I'd go for Plus/minus, even thought it's not the default, as it's similar to the way pivot table filtering looks.

You can also change how indented the different levels are, using the Stepped layout indentation property just above the Expand/collapse icon.  Here's the default:

Normal indentation What it looks like
Standard indentation ... ... looks like this

And here I've upped the indentation to the maximum of 40:

Maximum indentation Maximum indentation appearance
Maximum indentation ... ... and how it looks

Setting a slicer summary 

I don't think this is a new feature, but I don't remember seeing it before and don't remember it being announced!

Slicer summary

You can choose to show a summary of what you've chosen in the slicer in the slicer header.

 

The result for a hierarchical slicer can be quite verbose:

Slicer header verbose

By default, Power BI shows the choice you've made at each hierarchy level.

Because you haven't got much flexibility when setting a slicer header, you're still probably better off turning the slicer header off and setting a dynamic title instead.

This blog has 0 threads Add post