Forum Discussion

Sebastian's avatar
Sebastian
Icon for Advocate III rankAdvocate III
10 years ago

Problem with map and postal code

Hey,   I try to use the map visualization but it seems that it doesn't work well. Some postal codes where shown in the wrong country. So I try to use Land and Postal Code like   Location = Conca...
Need Help
Sebastian's avatar
Sebastian
Icon for Advocate III rankAdvocate III
10 years ago

For example the Code for the Coloumn Land is "CH" and Coloumn postal is "9016". (The format for the Coloumn "Land"is land and for Coloumn "Postal" is postal code).

 

If i use the Coloumn land in the visual all values where shown correctly.

If I use postal the visual shows the postal code "9016" in New Zealand but it is St. Gallen in Switzerland.

 

So my idea was to concatenate both.

My new Coloumn "Location" has the value "CH, 9016".

 

It seems that the visual ignore this value. All where shown correctly ecept values which are situated in Switzerland or Austria.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

The problem is that New Zealand uses four digit postcodes that are apparently the same as Switzerland/Austria. The map is taking its best guess. Specifically, a 9016 postcode would be somewhere in Otago, Southland in New Zealand. What if you put both the "Land" column and the "Postal" column in the Location field and then some other field in the Values field?

  • Sebastian's avatar
    Sebastian
    Icon for Advocate III rankAdvocate III
    10 years ago

    I have tried to concatenate "land" and "postal code" but it doesn't work for Austria and Switzerland. May the land code "AT" and "CH" doesn't work.

     

    I have concatenate "postal code" and "place". Now it seems to me that this is still working.

    • BlancaHernandez's avatar
      BlancaHernandez
      New Member
      10 years ago

      Hi, I am having the very same problem. 

      I have PLZ from Austria and Power BI notifies me that I need to add more information. I have also tried to concatenate "Austria" "AT" before and after the postal code. 

      Nothing worked for me, what do you mean by using the place? I dont have that information in my data set.

      How should the field look like so it can be represented in the map?

       

      Many thanks!

      • residentx's avatar
        residentx
        Icon for Helper IV rankHelper IV
        10 years ago

        There's a problem with the map service with NGA. They don't use Iso codes but use something else. I'm having problems too.