Filtering a bubble map using latitude and longitude from another visualization

[301066]

I have a bubble map using latitude and longitude and a bar chart with city. When I select the city in the bar chart the map displays the total for the city in one bubble and not, as required, the individual locations in the city. How do I get the two visualizations to interact properly?

[v-rzhou-msft]

Hi @301066 ,

Accoridng to your statement, I think you need two tables one is city for bar chart and another is location in city group for map chart.

Table1:

Table2:

Relationship:

When I select City1 in bar chart, map will only show the locations in selected city.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[301066]

Hi Rico

Thanks for your help on this.

I created the two additional tables and copied the relationship you suggested:

but the map bubbles still default to the total for the city, not the individual locations. I only have latitude and longitude in the map and only have city in the chart.

The table above the chart filters down to the individual accounts but the map doesn't.

Any ideas?

Thanks