Forum Discussion
Singapore Map for Visualization
Hi Power BI Community,
Would like to seek your help in providing a step-by-step tutorial for Power BI Map in Singapore 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 e0318476 ,
For this you need to have the following care with your data:
- Be sure that Postal code is on text format (because of the zeros)
- Categorize the country and the Postal code in the correct format:
Now setup you map on the following way:
- Location: Country + Postal Code
- Size: whateve column you need to make a count or a sum
In the image above I have made the drill down to the lowest level.
PBIX file attach.
5 Replies
e0318476 , You can check the shape map
or refer these old solution
https://community.powerbi.com/t5/Desktop/Singapore-Map-Visualization/m-p/156910
https://community.powerbi.com/t5/Desktop/Mapping-Singapore-as-a-state/m-p/656787
Map Json - Shape Map
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map
https://dataveld.com/2016/09/12/topojson-map-files-for-power-bi-shape-map/Hi,
Thank you for your reply. I have read through the solutions but it does not resolve my problem. Would sincerely appreciate the step-by-step tutorial.
Thank you.
Hi e0318476 ,
For this you need to have the following care with your data:
- Be sure that Postal code is on text format (because of the zeros)
- Categorize the country and the Postal code in the correct format:
Now setup you map on the following way:
- Location: Country + Postal Code
- Size: whateve column you need to make a count or a sum
In the image above I have made the drill down to the lowest level.
PBIX file attach.
Hi Miguel,
Sincerely thankful for your help!
