Solved: Front 0s in Zipcode

FrugalEconomist · ‎03-17-2017

Hello folks,

I was wondering how you handle the missing 0's in US Zipcodes?

Thank you

Sean · ‎03-17-2017

Convert the Column to Data Type Text in the Query Editor!

Click the icon on the left side of the Column name and select Text

This should fix it!

View solution in original post

Sean · ‎03-17-2017

Convert the Column to Data Type Text in the Query Editor!

Click the icon on the left side of the Column name and select Text

This should fix it!

Rusterfer · ‎07-19-2019

Changing the data type to text does not restore the leading zero in the zipcode text string, nor does it allow refreshing the data to include the leading zero from an Excel spreadsheet. I need the leading zero for proper sorting of the data.

Any suggestions?

littlemojopuppy · ‎07-19-2019

Are the zeroes present in the Excel spreadsheet? Is the data formatted as text in the spreadsheet? Excel does some things to guess what the user is looking for and sometimes guesses wrong.

Try this: https://community.powerbi.com/t5/Desktop/Leading-Zero/td-p/23131