- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
County Data
Hi,
I am working in PowerBI and notice that if a county is located in multiple states then it shows up in both locations or in a wrong state than it should. How can I get PowerBi to know the state of which a county is supposed to be located?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @nmck86,
I had a similiar problem with city names. When I would plot all USA cities, some would show up in the UK and France. I solved it by adding the zip code instead of the city name. It seems that ArcGIS doesn't have a feature to select the specific location you want. It does let you select one or many countries, but I still had city names showing up in other countries with the single country selected.
Short answer is you probably need to add more detailed data or switch your location type to Boundaries, not Points, and select the Location Type Counties.
Hope this helps,
Alan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would think adding a State column would be faster than adding a zipcode column. I've never used visuals by County - so I don't know what embedded recognition is there overall.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @nmck86,
I had a similiar problem with city names. When I would plot all USA cities, some would show up in the UK and France. I solved it by adding the zip code instead of the city name. It seems that ArcGIS doesn't have a feature to select the specific location you want. It does let you select one or many countries, but I still had city names showing up in other countries with the single country selected.
Short answer is you probably need to add more detailed data or switch your location type to Boundaries, not Points, and select the Location Type Counties.
Hope this helps,
Alan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As Alan said, zip code is usually the quickest solution, if you can add it to your data table.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-14-2023 05:20 AM | |||
03-11-2024 12:54 PM | |||
10-16-2023 08:41 AM | |||
03-29-2023 06:45 AM | |||
07-09-2024 04:22 AM |
User | Count |
---|---|
137 | |
107 | |
84 | |
60 | |
46 |