Slicer Hierarchy
Dragging a hierarchy into a report and change it to slicer... can we get a slicer with hierarchy (collapsible/expandable)?
Derrick Han
shared this idea
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!
98 comments
-
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 .
-
Rajib Mishra
commented
Hi ,
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.
-
Rajib Mishra
commented
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 -
Ghuiles
commented
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.
-
Piotr
commented
My opinion.
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.
-
Anonymous
commented
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
-
Anonymous
commented
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
-
Anonymous
commented
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.
-
Ketil
commented
Please fix this
-
MORANTIN
commented
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
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000727
https://xviz.com -
MORANTIN
commented
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. -
Rajib Mishra
commented
@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
-
Brittany
commented
Any updates?