let maps recognize data category hierarchy automatically
Currently maps don't seem to recognize the relationship between a country and a city, even if both columns have been set up with the corresponding data category in the model.
In a table with cities as "cities" and country as "country" in the data model, the cities are plotted in arbitrary countries instead of the country specified in the column for country.
Please let Power BI maps acknowledge the hierarchy of existing typed data categories and plot depending data points only in relation to their parent category context.
You may not feel the pain if you're in the US. I have a data set with cities all in New Zealand, but when I map them, they end up all over the globe, despite the "country" column specifying "NZ".
Please add your vote if you ever found a mapped dot outside of your desired country or continent.
The filled map recently has gotten so much worse. Please fix this!
Andrew T. commented
It's definitely an issue. Try mapping Birmingham, AL. You will find it in England. Similar examples exist. It's a little surprising when you can categorize the data as Location data.
Joop van den Heuvel commented
Seriously, this is my number 1 issue with maps. Please fix this!
Working from the Netherlands, it looks like Maps defaults to *every* other country in the world, before the map plots anything in the Netherlands: even the Dutch town of Breukelen sometimes gets plotted to Brooklyn, NY (which was named after Breukelen).
The only work-around that fixes this is to *always* concatenate country with any other location data, like city/province/etc. as a single string in the same field (eg.: 'Breukelen, The Netherlands').
Dan English commented
I would agree, particularly if you have defined a hierarchy for geography going from country->State->City->Zip Code then this should work. The context should be passed as you drill down into the data.