Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Singapore Map Visualization

I have a problem, I want to make Filled Map of Singapore. I have Postal Code, Country, and also the Address data for this. But when I put the postal code it point to Europe and America.   I also ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    I just tried adding a new calculate column with the formula below to combine the "Country" and "PostalCode", and showing the new created column on the Map, then it works just fine. 

     

    Column = data[Country]&","&LEFT(data[PostalCode],6)

     

    Here is the modified pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

I just tried adding a new calculate column with the formula below to combine the "Country" and "PostalCode", and showing the new created column on the Map, then it works just fine. 

 

Column = data[Country]&","&LEFT(data[PostalCode],6)

 

Here is the modified pbix file for your reference. :smileyhappy:

 

Regards

BobWong's avatar
BobWong
Frequent Visitor
4 years ago

Hi,

Don't think this will work with all the postcodes in Singapore. I had problems with some postal codes can't work with Bing Map. For example, Singapore 573859.