cancel
Showing results for 
Search instead for 
Did you mean: 

drill down based on legend

There must be an option of using a hierarchy of dimensions to drill down through. This would mean that as the user drills down the legend must change dynamically. This would mean that a user should be able to:

  • drill along the x-axis, for example time: Year > Month; AND
  • at the same time drill through the Legend. For example: Region > Country > Line of Business > Product.

The same functionlity is available in QlikSense and there is no reason why Power BI should not offer the same.

Status: New
Comments
Frequent Visitor

This would be an incredibly powerful tool that would reduce the number of bookmarks or tabs currently needed to create the same visual effect for the end users. For me to currently do this, I use a tedious visual layering method, showing/hiding numerous visuals with various bookmarks.

Frequent Visitor

Wish this was possible!  The current workaround is to create a copy of your table unpivoted on the columns you want to drill through. This is awkward and wasteful of memory. 

Frequent Visitor

I think dynamically switching the drill-down path (between axis and Legend columns) as I'm drilling down would be cumbersome (like drilling thgrough, where you have to right click, then enter a sub-menu, and finally select the target page).

Anyway, it would be great to drill down a %barchart LEGEND, the way we do it with a piechart.