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

44b973b6 7e8d-4baa-8fbe-3b60bd630c2b 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

f2f782bd d0e7-42f8-b44e-68828bb89f53 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

5cbacd44 014f-4658-a913-3cffd07a5271 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

d203a678 2d71-4e77-a178-3fdcaf2775cd 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

b1eb09b3 0d0e-4027-a73b-efdcd1f22704 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

93312a66 cf60-417a-a9e4-09bf0e8873dc 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

0fc94e3f 4bae-4f38-8f39-8db52fd36b1c 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

a8276610 6b80-49c3-8af8-9d2aab55b807 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.