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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.