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

Kirk Nason on 05 Jul 2020 22:12:41

RE: Slicer Hierarchy

That or use one slicer to filter the contents of another slicer.

Wenchang Han's profile image Profile Picture

Daniel (Australia) on 05 Jul 2020 22:11:16

RE: Slicer Hierarchy

This would be amazing if it is possible so that it is similar to how a multidimensional cube's hierarchies are used similar to COGNOS & SAS. Hence, instead of having 5 slicers, we only need 1.

Wenchang Han's profile image Profile Picture

salosteysv on 05 Jul 2020 22:05:44

RE: Slicer Hierarchy

I need it very much!
When it will be?

Wenchang Han's profile image Profile Picture

Brent Power BI User on 05 Jul 2020 22:03:08

RE: Slicer Hierarchy

Creating hierarchies via data modeling view or custom MDX "Named Sets" would be super-powerful in terms of visualizing data.

Wenchang Han's profile image Profile Picture

Christopher Woodward on 05 Jul 2020 22:03:04

RE: Slicer Hierarchy

SO need this! Please build this in. Slicers aren't working right, they are working more like filters.

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:02:46

RE: Slicer Hierarchy

Why still no possibility to build hierarchy in the slicer controll?

Wenchang Han's profile image Profile Picture

Power BI User on 05 Jul 2020 22:01:55

RE: Slicer Hierarchy

The more functional the slicers the better! They are one of the most important visualization tool.

Wenchang Han's profile image Profile Picture

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

RE: Slicer Hierarchy

Would be nice if when using a source which has hierarchies that those can flow through to the slicer. EG SSAS Cube source.