Forum Discussion
Helper IShape map duplicate counties
I figured it out.
You have to create a column concactenating the state fips code and the county fips code and then use that in your location field on visual. You can also just add the list below in the link to your data model.
https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
hi markjohnson952 - can you also share a screenshot of your datamodel? Do your table setup have unique keys for each country?
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
markjohnson952Hello,
In my data, my counties are just listed as a text string. Hennepin is just listed as Hennpin for the county.
hi markjohnson952 - this could be the issue for the conflict as the visual would not be able to differentiate between counties with the same name in different states. You would need to setup a county key which is unique for State + County combination - in my opinion this should help resolve the issue.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
- markjohnson952
Hello,
I have tried using a different TOPOJSON which has the complete State name and County name which are both in my data model in Power BI and I have the same issue. Below is the link to the file I am using.