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

Daniel Bartley on 05 Jul 2020 22:21:49

RE: Slicer Hierarchy

I'm all out of votes but this would be slick

Wenchang Han's profile image Profile Picture

Andy on 05 Jul 2020 22:21:48

RE: Slicer Hierarchy

This is a much needed feature. Ideally we could also use this kind of like the existing Chiclet slicer (use images as well as text, etc...). We have deep/ragged hierarchies all over our organization (customers, users, management, products, etc...). SUPER HELPFUL and necessary. Should also honor existing SSAS hierarchies in addition to 'manually' created hierarchies. Support in PowerBI desktop too please.

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:20:15

RE: Slicer Hierarchy

Please add this feature. I just want to be able to have a slicer for Year / Month

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:57

RE: Slicer Hierarchy

very much needed!!

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:53

RE: Slicer Hierarchy

Please, please implement this. We have clients with very deep hierarchies that they want to explore. Having 7 slicers on page is unworkable.

Wenchang Han's profile image Profile Picture

Tobias Owen on 05 Jul 2020 22:19:17

RE: Slicer Hierarchy

This would be a significant boost to existing filter options.

Wenchang Han's profile image Profile Picture

Andrew on 05 Jul 2020 22:18:53

RE: Slicer Hierarchy

I wish I could vote for this more than 3 times. This is essential to my business fully buying into power BI

Wenchang Han's profile image Profile Picture

Bob Gear on 05 Jul 2020 22:18:39

RE: Slicer Hierarchy

'+1 for this. I arrived on this page by trying to find out if this function exists.
I, too would like to see a proper hierarchy drill-down for use with SSAS hierachies in preference to cascaded single slicers

Wenchang Han's profile image Profile Picture

Jeroen van Steenbergen on 05 Jul 2020 22:15:39

RE: Slicer Hierarchy

Is still being considered? Would be a great addition to the live SSAS Connection.

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:13:10

RE: Slicer Hierarchy

we also very much needed it