cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: Singapore Map Visualization

Hi @conniedevina,

 

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)

map.PNG

 

Here is the modified pbix file for your reference. Smiley Happy

 

Regards

View solution in original post

5 REPLIES 5
Microsoft v-ljerr-msft
Microsoft

Re: Singapore Map Visualization

Hi @conniedevina,

 

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. Smiley Happy

 

Regards

Re: Singapore Map Visualization

@v-ljerr-msft

you can access this link

https://www.dropbox.com/s/017drclcup73v2s/SingaporeCountry.pbix?dl=0

 

Actually I already solved this with adding latitude and longitude every postal code manually.

 

I just wonder if there is another way to do it.

 

Thanks,

Regards,

Connie

Microsoft v-ljerr-msft
Microsoft

Re: Singapore Map Visualization

Hi @conniedevina,

 

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)

map.PNG

 

Here is the modified pbix file for your reference. Smiley Happy

 

Regards

View solution in original post

Re: Singapore Map Visualization

Hi @v-ljerr-msft

 

Thank you for your help! it works perfectly.

 

Thanks,

Regards,

Connie

Highlighted
nikahafiz Regular Visitor
Regular Visitor

Re: Singapore Map Visualization

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,101)