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 already tried to concatenate the Postal Code, Country, and the Address but there is no result or it pointing in one place in Singapore.

 

I already make a latitude and longitude data for Singapore.

 

I want the result it pointing to the address from the data.

 

Can you help me?

 

Thank you,

Connie

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

8 Replies

  • 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

  • sahisunkishala's avatar
    sahisunkishala
    New Member
    5 months ago

    Hello all,

     

    PowerBi Maps is retiring soon and we have to use Azure Maps from now on. The above solution worked fine with the PowerBI Maps. However it doesn't work with Azure Maps when you have latitude and longitude only for Singapore. Help me out if you have a solution for this.