cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
conniedevina Helper III
Helper III

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

conniedevina Helper III
Helper III

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

conniedevina Helper III
Helper III

Re: Singapore Map Visualization

Hi @v-ljerr-msft

 

Thank you for your help! it works perfectly.

 

Thanks,

Regards,

Connie

nikahafiz Helper II
Helper II

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 Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors