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

ac07a311 9b10-42b9-ab29-a3e629eef68d 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

ffc95a18 077c-4f05-875f-9b46c01a75f0 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

ffc95a18 077c-4f05-875f-9b46c01a75f0 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

cdd2e3b5 73bc-422c-8b21-2afcb61f47b6 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

e407c207 0b70-4892-9938-f06af6ff2522 on 06 Jul 2020 00:04:02

RE: Slicer Hierarchy

Please fix this

Wenchang Han's profile image Profile Picture

51f097e1 f818-4b8f-bd24-6cf7d361ea1d 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

ced5bc41 71d6-4fd4-8f02-9174f1aefb28 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

51f097e1 f818-4b8f-bd24-6cf7d361ea1d 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

4c78e4a6 e4aa-497b-9206-06568c920488 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

894eaae9 6cee-4b28-a3e8-cc4eadd76592 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