cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
radissoufan
Helper III
Helper III

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

2 REPLIES 2
selimovd
Super User
Super User

Hey @radissoufan ,

 

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
 

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?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors