Filled Map not mapping zip code with 0

Hi  Anonymous  ,

1. Have you set your column of zip codes to "postal codes" on the Modeling ribbon, under the Properties tab using the Data Category selector?  If not, you should do so as they will then display correctly.

2. Use the advance editor and changing the zipcode data type to "text".

This is the relevant document, hope to help you:

https://community.powerbi.com/t5/Desktop/Zip-Codes-that-start-with-0-0-is-not-Displaying/m-p/177478

https://community.powerbi.com/t5/Desktop/Zip-codes-from-database-do-not-map/m-p/15916

Best Regards,

Liu Yang

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

Hi  Anonymous  ,

You can change it like this:

1. Select the column you want to change.

2. Select Column tools.

3. Select Data category – Postal code.

This is the relevant document, hope to help you:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Best Regards,

Liu Yang

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

I changed my field to text and also identified the data as postal code, and my visual is still not mapping the east coast states. I saw online that Bing maps, which is what Power BI uses for the fill map, has issues with identifying zip codes that start with 0. 

Same issue. I set the column to text and the data catagory to zip with no dice.