Shared Drill Down Level on visuals with same hierarchy

Question

Hi I have a report that has multiple visuals which all share a hierarchy. When a user drills down on one of them, the others all get filtered to a that single value. Can we set visuals to maintain the same level of drilldown as each other if they share a hierarchy?

anonymous · Answer

I'm having the same problem. I have multiple matrixes on the same page and all have the same hierarchy - Business Unit&gt;Functional Area. When I drill down on a Business Unit it shows the Functional Areas for that Business Unit. By using "Drilling filters other visuals" when I drill down all of the visuals show the same Business Unit. However, to show the Functional Areas for the Business Unit I have to individually go to each visual and drill down. I need to be able to drill down on one and have all of the drill down to the Functional Areas for that Business Unit.&nbsp;&nbsp;

wcongrave · Answer

No. Thats the issue I've got. When I drill into one of the visuals, I'd like all of the others to drill down at the samne time - otherwise they are effectively useless as they only show one value.

wcongrave · Answer

Yes, it's very infuriating. I actually thought I'd put my initial post on the Ideas forum, so I'll move it to there!

wcongrave · Answer

I've just seen it's already been added as idea. Vote on the below&nbsp;https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35155678-synchronised-drill-down-across-multiple-charts-wit&nbsp;

mryoung · Answer

Did you solve this yet? because I have the same problem!

Forum Discussion

Shared Drill Down Level on visuals with same hierarchy

10 Replies

Related content

Matrix Visual Hierarchy Level Problem

Slicer and Visualization Hierarchy

Date hierarchy

Hierarchy Multi row visual

Dynamic Y range visual calculation in two level hierarchy