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,

 

Could you share some sample data which can reproduce this issue in your scenario, so that we can help further investigate on it? It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :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
        9 years ago

        Hi v-ljerr-msft

         

        Thank you for your help! it works perfectly.

         

        Thanks,

        Regards,

        Connie