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

     

     

     

parry2k's avatar
parry2k
Super User
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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I have the similar issue and tried with you sugesstion but it isn't working for me.

 

Here is my sample data:

 

  Total Consumer  Postal code    Country

   53                     0901              Norway

 

I followed step 1 and 2 as suggested but when I drill down it shows location of Mozambique insted of Norway.

 

Any help is appreciated.