Forum Discussion
Solved
Showing the zero with two digit postcode
Hi, I created a map from germany with only the two first digit of the postcodes and did the following steps used Power BI desktop enabled shape map created a zip 2 digit TopoJSON file and lo...
Hi MZCLN,
Can you please try the following in Power Query:
1. Make sure that the Zip Code COlumn is text
2. Add a column with the following formula:
if Text.Length([ZIP COdes]) = 1 then "0" & [ZIP COdes] else [ZIP COdes]
3. Result:
Please now use the new column for your visual.
Best regards
Michael
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your kudos.
It worked! Thank you very much, I´ve been on this for a while now! Thanks!
Awesome! Thank you for your feedback! 😊