Skip to main content
Microsoft Idea

Power BI

New

Drill down on Hierarchy in Legend

Vote (3) Share
Nick van Oort's profile image

Nick van Oort on 17 Nov 2022 11:06:47

Dear,


I've build a report with a 100% stacked bar chart.

The chart is build with the Month on the X-axis and the Revenue on the Y-axis.

I've created a Hierarchy of the products and their underlying categories. It's a Hierarchy of 5 levels.


I have the top Hierarchy level as the legend. I would like to select a part of a bar chart and drill down on that to the next level in the product category Hierarchy.

However, currently this is not possible as the legend does not allow more than one Hierarchy level. Besides that it's not possible to Drill Down on legend.


Could this be build in future updates? it would be very helpfull


Kind regards.

Comments (1)
Nick van Oort's profile image Profile Picture

Alyza Sison on 07 Jul 2023 01:52:27

RE: Drill down on Hierarchy in Legend

Agree on this. This is a powerful tool in visualization of hierarchy in legend. Hope this will be available in the updates.