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
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.

      • karaoan's avatar
        karaoan
        Icon for Kudo Kingpin rankKudo Kingpin
        10 years ago

        Same here but for a change with Australian post codes. Most showing correctly but some are shown in Europe although it's definitely an Australian post code. We also have the correct country field but PBI seems to ignore that even if its placed into the location field of the visual as an additional element to post code. There seems to be a bug somewhere.