Filled Map not mapping zip code with 0

[Anonymous]

Howdy!

So I have been able to successfully map most of data by zip code (see below) but the states of NH, VT, MA, ME, NJ are not mapping due to those zip codes beginning with a leading 0. Anyone know how I can get them to map on the default Filled Map?

[Anonymous]

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

 

 

[Anonymous]

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. 

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Where do you see the option to set them to "Postal Code"?

Both of the links you provided stated to change the field to text which I have done so and they still do not map those NE states I mentioned.