Forum Discussion
Power BI Australia Map
Hi Team,
I've been trying to build a map based on a postcode column. However, it spreads the locations all accross the globe, even though I added a coutry column. I'd appraciate any suggestions.
Hi Kacper98 ,
Do you want to show Post Code in Category label in your map visual?
Here I create a sample to have a test. In my sample I add an index column as Post Code.
I suggest you to try to use Latitude and Longitude to locate cities.
And then add [Post Code] into Location field in your map visual.
Then the visual will show error and you need to change the summarize function for columns in Latitude and Longitude to Average.
Result is as below. The label will show post code.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Thanks amitchandak, I don't think it resolved this issue entirely as by going through your solution I managed to only see the bubbles in Australia. However, a few postcodes that were applicable to Australia and somewhere in Europe, they're not showing on the map now.
Hi Kacper98 ,
Do you want to show Post Code in Category label in your map visual?
Here I create a sample to have a test. In my sample I add an index column as Post Code.
I suggest you to try to use Latitude and Longitude to locate cities.
And then add [Post Code] into Location field in your map visual.
Then the visual will show error and you need to change the summarize function for columns in Latitude and Longitude to Average.
Result is as below. The label will show post code.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
