Dragging a hierarchy into a report and change it to slicer... can we get a slicer with hierarchy (collapsible/expandable)?
Hi everyone. With the February release of Power BI Desktop we’ve released a Preview of this feature! You can add multiple fields to the slicer and use expand/collapse to drill through the values in the hierarchy.
We’d love to hear your feedback on it – please add comments to the thread here if there’s other things you’d like us to add.
Thanks again for voting and giving us feedback!
Steve Szatynski commented
The new slicer has a rather awkward backward compatibility. We have many reports that use a single lower level of various hierarchies. It was not possible to choose the lower levels until we recognized this update was released. We found had to enable preview features and then it would work , though it required extra clicks to add the hierarchy then toggle off the levels not desired. Perhaps when it released it will use a separate visual? Or even better play well with already created single level from hierarchy slicers .
We found one more bug. Say if we have a date hierarchy where Year - 2020 & Month is Jan,feb,mar …. Then if we sort on Year as descending, it should sort the month as well but it sorts Month Alphabetically which isn't correct.
Frank Preusker commented
I would like to see an option to set the indentation of the sublevels (eg by the number of pixel). I do agree with previous comments, that the visual is getting too wide with several sub-levels. Making the indentation flexible would overcome this issue.
This is one of the most expected features & we are happy about that but I think there is bug
For example if we have Year -> Month -> Week ending dates,
The sort order doesn't work properly. IF we set Sorting on Week Ending date & order as descending it shows 2014 first & 2020 at the bottom whereas it should sort the year in descending order as well as its a hierarchy & week is the lowest level . This was working fine with the existing Custom Hierarchy Slicer
For now we have to sort of year but month ,week would be showed in ascending order which business won't agree. Could we check this bug
My opinion: The new slicer looks ok but it takes then too much place in the width and in the height if we expand it (i.e. Continent, Countries, Provinces, Cities)
To make it more slim, perhaps playing with the colour and the form would help.
Filip Stopiński commented
Chevron is too big indeed as per other comments. Nodes also take way up too much space horizontally when expanded. Also the slicer is quite buggy - doesn't always work - in my case it only does when I convert a data table to this slicer. Not when I simply drag a hierarchy over to the slicer. Also when trying to collapse nodes I get render errors.
Build some hierarchy and compare your slicer to generally very good HierarchySlicer - much better design and overall experience etc.
Slicer header has no field to enter a title. Chevron is too big for me. The single selection icon looks weird :)
Marco Smulders commented
The preview version of Feb2020 does not work right in case of "single select". I want to force to select one item of the lowest hierarchical level. But when user selects an item in the top level, all items on lowest level will and can be selected. Please fix this.
Eric Marshall commented
Can we please add the ability to customise the text that appears in the Slicer header?
By default, the new hierarchical slicer just separates the items in the hierarchy with commas, which is really not ideal when dealing with a hierarchy with lots of levels.
I see this in Feb 2020 release preview. It will be good to add in blank members hiding feature. it will be useful in hiding blank nodes in an unbalanced hierarchy like org hierarchy
What would be great is if we could also control the top hierarchy level shown in the visual based on a measure.
This would be extremely useful for having multiple customers using the same report with Row Level Security, as one customer could have a 2 level hierarchy and another could have 3 levels. Having to show all 3 levels for all customers is not ideal. This would be fantastic
this would be great having it with a drop down. to be honest it really should already be there but having had multiple people in the business ask for this recently it is sorely needed
Jesse Gorter commented
please make sure it works in a dropdown, without having to adjust the height of the dropdown.
Please fix this
your visual is good but still your mark in the right corner , that couldn't be use in production , suppose need a licence for don't see the mark
Jay Anantharaman commented
Try out our Hierarchical Filter by xViz that was released very recently
need a feed back , still in evaluation over five years...
Germo Görtz commented
5 years, but this very important request is still not implemented. I understand that Microsoft want to death SSAS MD and to nudge us to move to SSAS tabular. But there are so much features not possible in SSAS Tabular and SSAS MD is still alive. Please support the usage of hierarchies which is a main concept of OLAP databases.
This missing feature is the main reason why I classify PowerBI as "not usefull for SSAS MD" for many years.
@Team, With plenty of issues with the existing 3rd party Hierarchy Slicer. Is there a roadmap on when Microsoft is planning to release their own Hierarchy slicer as business is rigorously following up on this requirement. Would be of great help