Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello folks,
I was wondering how you handle the missing 0's in US Zipcodes?
Thank you
Solved! Go to Solution.
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!
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!
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |