ArcGIS not displaying data for some US states?

[sfmike99]

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?

[Anonymous]

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.

[Anonymous]

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.

[sfmike99 · Accepted solution]

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")

[rajendraongole1]

Hi @sfmike99  - can you please check the below links: hope it helps you.

https://community.esri.com/t5/arcgis-for-power-bi-blog/location-mapping-issues-in-arcgis-for-power-b...

https://doc.arcgis.com/en/power-bi/design/change-the-location-type.htm

Create an ArcGIS map in Power BI - Power BI | Microsoft Learn