Filled Map Struggling to Show All 3 Digit Zips

[Rhonbarger]

I'm trying to show zones by 3 digit zip in a filled map.  I have a location hierarchy created from my destination data (Country, State, 3 Digit Zip, 5 Digit Zip).  My locations are linked to my zone assignment via the 3 digit zipcode.  The map shows most 3 digit zip areas correctly however a few appear as uncolored gaps/holes.   These gaps are correctly mapped at the state and 5 digit zip level however.  What is causing this issue at the 3 digit zip level and how can I fix it?

[v-tangjie-msft]

Hi @Rhonbarger ,

You can try to fix it by creating a hierarchy of: State - 3 Digit zip code - Zip code. And then drill down by hierarchy.

In this sense the heat map will display the ones that started with a 0.

Please refer to the following document for more information.

Solved: Filled Map by 3 digit Zip Code - Microsoft Power BI Community

Power BI Filled Map Tool - some data doesn't display (microsoft.com)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Rhonbarger]

I have that hierarchy already created.  While it did fill in the 3DZs with leading 0s, it created gaps in other areas like south illinois and middle of Nebraska (see map image in original post for example)