Singapore Map Visualization

[Anonymous]

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

[v-ljerr-msft]

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. 

Regards

[Anonymous]

@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

[v-ljerr-msft · Accepted solution]

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. 

Regards

[BobWong]

Hi,

Don't think this will work with all the postcodes in Singapore. I had problems with some postal codes can't work with Bing Map. For example, Singapore 573859.

[e0318476]

Hi,

Could you provide a step-by-step tutorial to do this by importing this dataset to Power BI and creating the map? Thx.

Name of Location	Full Address	Country	Postal Code
Garden By The Bay	18 Marina Gardens Dr, Singapore 018953	Singapore	018953
Trick Eye Museum Singapore	26 Sentosa Gateway, #01-43/44, 098138	Singapore	098138
Mandai Zoo	124 Mandai Road, 779389	Singapore	779389

[Anonymous]

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

[Anonymous]

Hi @v-ljerr-msft

Thank you for your help! it works perfectly.

Thanks,

Regards,

Connie