Forum Discussion
Solved
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...
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 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!