Forum Discussion

Kacper98's avatar
Kacper98
Regular Visitor
2 years ago
Solved

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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.