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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi,

is there a way to put a proper name to each location such as 'building xyz' instead of being 'singapore,109683' as an example?

tks: -nik