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!
With the new ability to "sync slicers" this is needed more than ever.
The custom Hierarchy Slicer is such a staple for users that I'm shocked MS hasn't updated their own by now.
I really need a hierarchy slicer that is not a custom add on too
Sn Mailist commented
Will, are you sleeping/hibernating for 3 years ?
Joel Faltermeier commented
Can someone please bring this one back up from the dead?! Under review Dec. 2014. 3 years later?
As others noted, Custom Hierarchy slicer has many issues and limitations.
sn gShadow commented
Will, have you already resigned ?
The custom visual hierarchy slicer is no longer working, so we really need the feature asap
Cray Kuo commented
This is required
Stuart Charles commented
"Under Review" since 2014? This is a very important piece of basic functionality, please keep considering. Most of it is already available with the custom hierarchy slicer - we pretty much need the same just with a collapsible option so it doesn't take up too much space on the report.
Will Charsley commented
We have multi level product hierarchy (Total>Category> Sub Category 1> Sub Category 2> Merchandise Area > Planning Group > Sub Planning Group > SKU). Basically, we need 6 or 7 slicers just for our Products, meaning we seriously lack space for much else on the screen. We really need this!
I agree that a hierarchy slicer makes a lot of sense for basic functionality.
Jeff Roberts commented
Custom visual seems to become broken as of late - scroll bar not working, error when opening in PBI Desktop - so need for this improvement has increased
Jack Wells commented
Currently using this custom visual but it would be much better to have this as part of Power BI by default.
Any update on this?
I suggest two improvements :
1) combinate "text" and "numerical" values, i mean : first level hierarchy = check boxes for texte values as name for a range of nurmeric values, second level = numeric value, with the ability to use "between" like in regular nurmerical slicer
2) ability to use the scroll list like in a regular slicer.
efi goldman commented
I use today the custom visual: Hierarchy slicer. It has issues. And doesn't support lots of members, sorting etc.
Please help us here this means a lot to my clients.
Jared Knutzen commented
This would be incredibly helpful. I find myself going to the custom visuals to get this - but they don't work as well, they don't look/feel the same as built-in slicer options, and they aren't as reliable.
Jeff Brown commented
Yeah, we're currently having to split out a three-level hierarchy into three slicers. Due to the lack of screen real-estate that's not really acceptable. It doesn't even function in the visual/page/report level filters, so that's not a particularly palatable workaround either.
Ozlem Ozgur commented
I've used this feature. It is very helpful I agree. There are some visual and functional issues with the visual.
1. When not all of the secondary level items selected top level check box still shows like all of them selected.
2. even top level item selected and secondary level shown selected for all of the item when the data refreshed and new item appear on secondary level it is not selected.
Stuart Charles commented
This would be excellent. There is already a custom visual that can do this, so all that needs is to add a show / hide button so it doesn't take up too much room on the report page, as per the current slicer delivered visual.
Why is it under review since December 2014? I still don't see that!!! Please do that, it's very useful.
Andrejs Gordijenko commented
This feature is really needed! There is a custom visual for this, but this should be a part of OOTB functionality in Power BI