Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Drilling down a chart by another chart

Hello ... I have 2 charts

all of the 2 charts has a same dimension hierarchy of 3 levels (map geo location... and barchart geo location)

I want if I drill down in the map 

I want the bar chart to drill down too by the map drilling...

is there a way for that

Need Help

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    I'm not sure if I fully understood your question.

    If you use the same dimensional tables, there is an interaction between the visuals. So you if you select a value from the map, the bar chart should adapt.

     

    As I understood you want to change that from highlighting to filtering, right? For that you can change the interaction of the visuals from highlight to cross filter:

    Change how visuals interact in a report - Power BI | Microsoft Docs

     

    If I didn't understand the question right, maybe just put a few screenshots and try to describe what you want exactly to happen.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello ... thank you for responding

      My question about drilling down in bar chart if I drilled down in the map... 

      I mean When I drilled down the next level in the map ... barchart filterd correctly but with previous level... what I mean it didnt drill down when the map drilled down

      eg:

      I have US with total 5000 and next level NY 3000 and seattle with 2000

      when I drill down to NY on the map

      the bar chart change to 3000 but still holding US text as label... I want it to drill to display NY when I drill in the map... is that possible?