Forum Discussion
Shape map duplicate counties
I am using the Shape Map with a TOPOJSON to identify sales by county. In the cases where you have the same county name in multiple states (Jefferson, Orange, Washington) my sales numbers are all the same for those counties (Jefferson in Colorado has $10 in sales while Jefferson in Oregon also has $10).
How can I fix this in my PBIX or JSON?
Below is the link to the TOPOJSON file.
Thanks!
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
7 Replies
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!
Hello,
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!
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
