Forum Discussion
Map showing wrong location
Hey All,
I have a map visualisation that shows wrong places.
Examples are in screen shots below.
What can I do about it?
Some points, however, show in the correct place.
Cheers!
A
I have done that already. Tried a few categories, that is why it is not showing correctly in the screenshot.
Anyhow,I found the root cause.
I have duplicates on the location name --> Same location name but in a different state. So the map is showing an average lat/long for all places with the same name.
The solution:
I have created a custom column that will concatenate the (Location, State, Country). That resolved my problem.
Cheers!
A
5 Replies
Hi Anonymous
It seems the location is confusing the mapping.
The map will behave differently if you specify the column to be a City or County etc.
Please change the "Data category" to the correct format: city, state, or something else.
https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hey v-juanli-msft
Thanks for your reply.
I am using Latitude and Longitude and not city/state/country names.
For example Longrech
In bing maps shows the correct location.The values I have in my dataset is -34.87, 150.524 as you can see in the screenshot below for bing.
However, in PBI the numbers are different.
And my settings
Cheers!
AHi Anonymous
In Modeling->Data category
change columns "Latitude" and "Longitude" to "Latitude" and "Longitude" type.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
