Forum Discussion

MZCLN's avatar
MZCLN
Regular Visitor
3 years ago
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...
Need Help
Tutorial Requests
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, MZCLN ;

Can you tell me the type about your excel.

In my excel, i change the type to text.

Or you could add "'" before the number.

If not ok, can you share the excel.How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MZCLN's avatar
    MZCLN
    Regular Visitor
    3 years ago

    Hi yes, I have a custom format with 0#, so it´ll show the zero. If I try it with the text format it´s still not showing the two digit in PowerBI