Forum Discussion
Map showing wrong location
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
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
Thanks for explaining what was happening and finding your own solution. It kind of makes sense why Power BI is doing that , but for some reason, Microsoft recommends NOT using a concatenated string in one of their docs pages and says that if all fields are defined wiht the data category and then put in a hierarchy, that will be used to determine the location.
My other thought would be to remove the location information from the Location field well and put it in the Tooltip. Bubble maps work with just lat/lon fields and no location. That way, the lat lon should not get aggregated.
Please let me know if you have time to play with this as well and if it gives you what you need.