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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.