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
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. :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
