Skip to main content

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 05 Aug 2020 20:30:23

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

735af055 87c0-403f-b1ac-180c88a25ca8 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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:35:30

RE: Slicer Hierarchy

Really needed feature. Please add it ASAP.

Wenchang Han's profile image Profile Picture

8ea408ca 499c-4e87-b9fa-190e4d01e5e3 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

d416a68f 966c-408d-a15e-b7ee078fc8eb 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

7d183a27 488f-4380-8bd5-557ce917ae51 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

069e66e6 85b3-4567-b5e9-65e94bc155a8 on 05 Jul 2020 22:25:07

RE: Slicer Hierarchy

yes, indeed, we want this feature too.

Wenchang Han's profile image Profile Picture

5fc05070 1eae-47fb-95fe-943ddf02354d 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

6ac2e7cf 22d9-43b7-aa7b-5be45d890f48 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

70af0aa0 3ab8-40d4-80b3-0bfbf33add3b on 05 Jul 2020 22:22:28

RE: Slicer Hierarchy

Do want for SSAS hierarchies!