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

a466c1a2 a24a-42a4-a730-a99aba023c58 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

dfd5263a 806d-4dcc-a6f0-643e90aa0d5f 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

203f6281 b2ec-423f-8c06-1de616e3ccbf 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

8c609ad3 3843-42c5-a4e0-8237d29f0bc9 on 05 Jul 2020 22:19:57

RE: Slicer Hierarchy

very much needed!!

Wenchang Han's profile image Profile Picture

1f627ec2 31a3-478b-a75a-30f9602b38ed 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

c92a060f 4ff7-41b5-b219-2ecd8f13c602 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

3e3e97ee b055-495e-8d44-7d3146f43abf 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

6680314b a0fa-48bb-9014-d49709b36739 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

d93874c5 ac4c-ea11-a812-000d3a579c39 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

adea2fa3 49f0-455b-9211-f9145311080c on 05 Jul 2020 22:13:10

RE: Slicer Hierarchy

we also very much needed it