Forum Discussion
Singapore Map Visualization
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
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
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
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
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 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.
