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

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.