Forum Discussion

hassanwasef's avatar
hassanwasef
Frequent Visitor
9 years ago
Solved

How can I locate Places on map using PostalCode

Hello, We have started using PowerBi for data visualization, We needed to view locations on power bi map, but all i have is postal codes of these locations. the places are all located in Saudi Arabi...
Show and Tell
  • parry2k's avatar
    parry2k
    9 years ago

    I had the similar issue and this is how it was resolved:

     

    1. make sure your Data category your fields is correct, you can set category in modeeling tab, select category "Country/Region
    for your country field and set category "Postal code" for your postal code field.

    2. on Map visual, drop Country and Postal field as shown below

    3. You will see drill down icon on your map visual, like below.

    4, Click Hierarchary drill down button and you will see your data in correct country/postal area

     

     

     

Juliän's avatar
Juliän
Advocate I
8 years ago

This Topic is not solved! In Germany we have similar problems.

German postcode 99734 -> Nordhausen in Thüringen, is from Bing Maps located in Alaska, that's makes no sense. And we have much more examples.

 

I categorized the data. I created hierachies, with country. I concatenated it with Country infront of postcode, nothing works.

 

Please fix that Bugs!

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I'd like to suggest you to use a calculated column who contains detail address information to help map visual to accurate the location.

     

    For example:

    Place = [Postal Code]&","&[Country]

     It worked in my case.

    • jessical_7's avatar
      jessical_7
      Frequent Visitor
      2 years ago

      Hi there,

      I just tried the solution above and wondered if this calculated column needs to assign a data category. Thanks in advance.

      Kind Regards,

      • jessical_7's avatar
        jessical_7
        Frequent Visitor
        2 years ago

        An answer to the question above: it doesn't require me to assign a certain data category for it, and making sure of the comma is between post code & country, then drag calculated column to 'Location' field on your map. Problem solved!
        Many thanks,