Reply
sfmike99
Advocate II
Advocate II
Partially syndicated - Outbound

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?

 

sfmike99_0-1743053365278.png

 

1 ACCEPTED SOLUTION
sfmike99
Advocate II
Advocate II

Syndicated - Outbound

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

View solution in original post

4 REPLIES 4
v-pbandela-msft
Community Support
Community Support

Syndicated - Outbound

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.

v-pbandela-msft
Community Support
Community Support

Syndicated - Outbound

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
Advocate II
Advocate II

Syndicated - Outbound

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
Super User
Super User

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)