Forum Discussion

WCONGRAVE's avatar
WCONGRAVE
Icon for Advocate I rankAdvocate I
7 years ago

Shared Drill Down Level on visuals with same hierarchy

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...
Need Help
WCONGRAVE's avatar
WCONGRAVE
Icon for Advocate I rankAdvocate I
7 years ago

Hi,

 

thanks for your reply. I've mocked up an example with dummy data (link below). There's 4 charts, all of which use the same Hierarchy (REGION HIERARCHY - Region>Area>Site) on the Axis/Legend. When a user drills into one of them, I'd like all of the others to also drill down to the next level.

 

https://ufile.io/wau61

 

Hope that makes things clearer, I appreciate you looking at this.

Warwick

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi WCONGRAVE,

 

Do you want to get the drill down filter like below?

 

 

 

If it is, you could refer to this document about Drill-down one field at a time.

 

Best  Regards,

Cherry

  • WCONGRAVE's avatar
    WCONGRAVE
    Icon for Advocate I rankAdvocate I
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I'm having the same problem. I have multiple matrixes on the same page and all have the same hierarchy - Business Unit>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.

       

       

      • WCONGRAVE's avatar
        WCONGRAVE
        Icon for Advocate I rankAdvocate I
        7 years ago

        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!