Power BI Australia Map

[Kacper98]

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.

[Kacper98]

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.

[Anonymous · Accepted solution]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Kacper98 , You may have create full location using country

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks#2-use-more-than-one-...

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-locate-Places-on-map-using-PostalCode/m-...