- 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

ArcGIS not displaying data for some US states?
Made a choropleth map in ArcGIS for Power BI. Data is by fips code, and displays correctly except for a handful of states. There is data in the table for fips codes in those states, and I verified they match the expected locations. Any ideas?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Ah it was missing the leading zeroes in the fips fields. I was thrown off because it was state specific. Easily remedied in Power Query:
Text.PadStart(Text.From([FIPS]), 5, "0")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @sfmike99,
We hope your issue has been resolved. If so, please "Accept as Solution" and give 'Kudos' so that community members can find it easily.
Please continue using the Microsoft community forum.
Regards,
Pavan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @sfmike99,
Could you please confirm if this issue has been resolved? If it has, kindly mark the helpful reply and "Accept it as the solution". This will assist other community members in solving similar problems more quickly.
Thank you,
Pavan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Ah it was missing the leading zeroes in the fips fields. I was thrown off because it was state specific. Easily remedied in Power Query:
Text.PadStart(Text.From([FIPS]), 5, "0")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @sfmike99 - can you please check the below links: hope it helps you.
https://doc.arcgis.com/en/power-bi/design/change-the-location-type.htm
Create an ArcGIS map in Power BI - Power BI | Microsoft Learn
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-27-2024 06:49 PM | |||
12-04-2023 08:41 AM | |||
04-18-2024 10:33 PM | |||
04-29-2024 05:23 AM | |||
12-20-2023 01:33 PM |
User | Count |
---|---|
132 | |
105 | |
86 | |
55 | |
46 |