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

Power BI User on 06 Jul 2020 00:08:24

RE: Slicer Hierarchy

I see this in Feb 2020 release preview. It will be good to add in blank members hiding feature. it will be useful in hiding blank nodes in an unbalanced hierarchy like org hierarchy

Wenchang Han's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:09

RE: Slicer Hierarchy

this would be great having it with a drop down. to be honest it really should already be there but having had multiple people in the business ask for this recently it is sorely needed

Wenchang Han's profile image Profile Picture

Power BI User on 06 Jul 2020 00:07:07

RE: Slicer Hierarchy

What would be great is if we could also control the top hierarchy level shown in the visual based on a measure.

This would be extremely useful for having multiple customers using the same report with Row Level Security, as one customer could have a 2 level hierarchy and another could have 3 levels. Having to show all 3 levels for all customers is not ideal. This would be fantastic

Wenchang Han's profile image Profile Picture

Jesse Gorter on 06 Jul 2020 00:06:22

RE: Slicer Hierarchy

please make sure it works in a dropdown, without having to adjust the height of the dropdown.

Wenchang Han's profile image Profile Picture

Ketil on 06 Jul 2020 00:04:02

RE: Slicer Hierarchy

Please fix this

Wenchang Han's profile image Profile Picture

MORANTIN on 06 Jul 2020 00:03:46

RE: Slicer Hierarchy

your visual is good but still your mark in the right corner , that couldn't be use in production , suppose need a licence for don't see the mark

Wenchang Han's profile image Profile Picture

Jay Anantharaman on 06 Jul 2020 00:03:38

RE: Slicer Hierarchy

Try out our Hierarchical Filter by xViz that was released very recently

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000727
https://xviz.com

Wenchang Han's profile image Profile Picture

MORANTIN on 06 Jul 2020 00:03:31

RE: Slicer Hierarchy

need a feed back , still in evaluation over five years...

Wenchang Han's profile image Profile Picture

Germo Görtz on 06 Jul 2020 00:01:47

RE: Slicer Hierarchy

5 years, but this very important request is still not implemented. I understand that Microsoft want to death SSAS MD and to nudge us to move to SSAS tabular. But there are so much features not possible in SSAS Tabular and SSAS MD is still alive. Please support the usage of hierarchies which is a main concept of OLAP databases.
This missing feature is the main reason why I classify PowerBI as "not usefull for SSAS MD" for many years.

Wenchang Han's profile image Profile Picture

Rajib Mishra on 06 Jul 2020 00:00:11

RE: Slicer Hierarchy

'@Team, With plenty of issues with the existing 3rd party Hierarchy Slicer. Is there a roadmap on when Microsoft is planning to release their own Hierarchy slicer as business is rigorously following up on this requirement. Would be of great help