Forum Discussion
MAP showing wrong locations when using counties
Microsoft EmployeeHi lp4034,
Please refer to power-bi-map-tips-and-tricks#in-the-dataset-tips-to-improve-the-underlying-dataset.
1. Create a new calculated column.
Country = "United States"
2. Add two columns in the "Location".
Best Regards,
Dale
Thank you for the feedback Dale, and I took your advice and built a map visual using the county field and the country field as location. However, the map still thinks Plymouth county (for example) is in Great Britain (along with a dozen others). I'm not sure why it is not recognizing the country. I have defined the county column as data type "county" and country column as data type "country". If I then add in the zip code to the location, the map looks correct and it all maps into the United States fine (at Country level or zip code level). But even with this setup, I can't drill down into the county level--it goes back to Great Britain.
The only alternative I have been able to make work is to concatenate county and country as in "Plymouth, United States" and use a data type of "place". This maps perfectly--but then I lose my ability to have a geo-hierarchy that I can drill up and down within.
- v-jiascu-msft
Below is a link to my territory file. It contains only the New England area--and only the locations we need within New England--so it is small. The "MyPlace" column was used in my attempt to concatenate County and Country instead of using the Country, State, County, City, Zipcode hierarchy. Only the county level gives me trouble regardless of whether I use "MyPlace" or the territory hierarchy.
https://drive.google.com/open?id=1_4-Xa3o6I6B-2Dzh1YnYhLrLP4sYkg58
Thank you for your time and assistance.
- v-jiascu-msft
Hi lp4034,
Please check out the demo in the attachment. The lowest level of the hierarchy should be marked as "Place".
I will still remind you about the privacy.
Best Regards,
Dale