Forum Discussion
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 ...
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,
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,
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 |