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
We plan on bringing hierarchy support to the core visual slicers in Power BI. It’s in the works now!
91 comments
-
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?
-
Karo
commented
Any updates ? It will be very helpful
-
Anonymous
commented
@Will Thompson, any updates?
-
Anonymous
commented
@will Thomson, You should design a filter that has the hierarchy mode, or as a complement to the filter you have.
-
Martin Ohlsson
commented
@Will Thompson, any updates? Alternatively please just implement the Hierarchy Slicer Custom Visual as a default Visual in Power BI.
-
KumarBI
commented
This is a basic requirement and must have.
-
Dejan
commented
Excel has it, why not Power BI? Such a basic feature
-
Matthias
commented
This would be important also for our organization
-
MW
commented
This would be important also for our organisation
-
Anonymous
commented
As others have said, the custom one is a start but lacks in many areas, a hierarchy slicer is a basic requirement.
-
Anonymous
commented
The custom visual hierarchy slicer does not work well. Syncing slicers does not work. Exporting to pdf does not show this slicer as it is not Microsoft certified.