Skip to main content

Power BI

New

drill down on legend

Vote (54) Share
's profile image

on 09 Aug 2016 16:58:59

Currently when you do a drill-down it's drills on your axis. In case you have put something on the legend you can't drill on it. For situations where you have i.e. some time hierarchy on the axis and some product hierarchy on the legend it might be very helpful if you can simply choose to drill on either the time or the product hierarchy...

Comments (6)
's profile image Profile Picture

e289549c 4eec-4405-a229-304913b5dc33 on 16 Aug 2020 03:57:46

RE: drill down on legend

Exactly what I am searching for...

's profile image Profile Picture

a4ba5d2b 2ef9-4a44-aa6a-1873dcabcd39 on 16 Aug 2020 03:56:31

RE: drill down on legend

Oh, boy do I need this functionality. I've been asked for that level of interactivity specifically from my executive users, and I'm stuck answering "sorry, that's not possible yet..."

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 16 Aug 2020 03:56:26

RE: drill down on legend

The ability of Drilling Up/Down on a hierarchy put in the Legend field would be a great feature to have! This would definitely gain Power BI more advantage over other BI tools!

's profile image Profile Picture

6c129135 961a-4b7b-90f0-1392473cb46c on 16 Aug 2020 03:56:07

RE: drill down on legend

It would also be great if there was some indication on the visualization itself that showed you what values you drilled down on. As the datasets get more dense it gets easy to get lost in layers of hierarchies, I think this would be a good way to keep the information in perspective.

's profile image Profile Picture

aaf7e1ca 6db4-4350-bb99-b48a482676ec on 16 Aug 2020 03:55:27

RE: drill down on legend

I fully agree with the idea. This function is lacking in PowerBI compared to e.g. Tableau.
Tableau offers you the possibility to choose from even more hierarchies, for instance product, customer segment, geography etc via right mouse click

's profile image Profile Picture

4f71609d 3e3f-45ca-9511-7597e771c134 on 16 Aug 2020 03:55:22

RE: drill down on legend

This would be a great feature as often times I have hierarchical fields that I would like to drill through on a line chart which trends over time.