Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filled Map not mapping zip code with 0

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.