Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
301066
Frequent Visitor

Filtering a bubble map using latitude and longitude from another visualization

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?

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

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:

RicoZhou_1-1663307618371.png

Table2:

RicoZhou_0-1663307610541.png

Relationship:

RicoZhou_2-1663307627230.png

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

RicoZhou_3-1663307718140.png

 

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.

Hi Rico

Thanks for your help on this.

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

301066_0-1663322216192.png

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.

301066_1-1663322398307.png

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

301066_2-1663322507055.png

Any ideas?

Thanks

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.