Skip to main content
Microsoft Idea

Power BI

Completed

Slicer Hierarchy

Vote (1766) Share
Wenchang Han's profile image

Wenchang Han on 03 Dec 2014 08:39:36

Dragging a hierarchy into a report and change it to slicer... can we get a slicer with hierarchy (collapsible/expandable)?

Administrator on 27 Dec 2020 02:04:01

With the June release of Power BI Desktop we've made this feature generally available. Thanks for voting and giving us feedback!

Comments (108)
Wenchang Han's profile image Profile Picture

Andrejs Gordijenko on 05 Jul 2020 22:36:08

RE: Slicer Hierarchy

This feature is really needed! There is a custom visual for this, but this should be a part of OOTB functionality in Power BI

Wenchang Han's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:35:30

RE: Slicer Hierarchy

Really needed feature. Please add it ASAP.

Wenchang Han's profile image Profile Picture

Will on 05 Jul 2020 22:34:47

RE: Slicer Hierarchy

Agreed that this is still needed. Custom visuals are great and very useful in certain places, but we are uncomfortable with rolling out dashboards to the business containing visualizations that are not officially supported.

The other thing we still need is the ability to filter the options that are given by the slicers so that not everything is visible for selection. We used to be have a workaround for this where you could flip it to a table and then add a filter, then flip it back. I cna no longer do this.

Wenchang Han's profile image Profile Picture

Daniel LEMEE on 05 Jul 2020 22:29:00

RE: Slicer Hierarchy

Hierarchy slicer is great, it can be more if "select all" will be implemented.

Wenchang Han's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:28:05

RE: Slicer Hierarchy

Hi All,

In think Hierarchy Slicer Published by Jan Pieter Posthuma is good. we should mark it as completed. Thank you!

Regards
Sohial

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:26:31

RE: Slicer Hierarchy

The Hierarchy Slicer in the custom visuals gallery is a great example of how to accomplish this idea in Power Bi. Something similar to that custom visual but officially supported would be great.

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:25:07

RE: Slicer Hierarchy

yes, indeed, we want this feature too.

Wenchang Han's profile image Profile Picture

Xiang on 05 Jul 2020 22:25:07

RE: Slicer Hierarchy

power BI connect SSAS cube mode tabular no hierarchy !!!!
pls add it!

Wenchang Han's profile image Profile Picture

ZLJ on 05 Jul 2020 22:24:05

RE: Slicer Hierarchy

There is now a hierarchy slicer available in custom visuals. Been playing with it today and its not perfect, but has helped improve my reports immensely.

Wenchang Han's profile image Profile Picture

Daniel on 05 Jul 2020 22:22:28

RE: Slicer Hierarchy

Do want for SSAS hierarchies!