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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
hdaoued
Frequent Visitor

show expected and real location on the same MAP

I have one table containing object id and then expected location and real location. I would like to display the expected location and real location on the same map visual so that the user can easily see how far from each other the loctions are. Is this feasible in Power BI?

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

I think you'd need to unpivot the data so that you've got object ID, location type ( expected or actual ) and location. you could then use the location type as the legend.

View solution in original post

2 REPLIES 2
hdaoued
Frequent Visitor

Thanks @johnt75 That is working fine but the only issue is that i can't distinguish between the locaion of two objects if they have the same one. I tried to add the object ID in the tooltip but that does not solve the issue. Any ideas?

johnt75
Super User
Super User

I think you'd need to unpivot the data so that you've got object ID, location type ( expected or actual ) and location. you could then use the location type as the legend.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors