BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This month's update doesn't include many changes - the biggest being probably the emergence of the hierarchical slicer from preview.
- Power BI June 2020 update - summary of new features
- Hierarchical slicers (this blog)
- Much-improved mobile report designer
- Individual dots on line charts
- Automatic refresh
- AI insights in Query Editor
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.
What happens when you want to choose by different levels of a hierarchy?
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:
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:
The three sets of icons on the drop-down list are Chevron, Plus/minus and Caret. Chevron is shown above, and the other two are shown below.
Here's what Plus/minus and Caret symbols look like:
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:
|Standard indentation ...||... looks like this|
And here I've upped the indentation to the maximum of 40:
|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!
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:
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.