Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Map showing wrong location

Hey All, I have a map visualisation that shows wrong places. Examples are in screen shots below. What can I do about it? Some points, however, show in the correct place.   Cheers! ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi v-juanli-msft 

    I have done that already. Tried a few categories, that is why it is not showing correctly in the screenshot.

    Anyhow,I found the root cause.

    I have duplicates on the location name --> Same location name but in a different state. So the map is showing an average lat/long for all places with the same name.

    The solution:

    I have created a custom column that will concatenate the (Location, State, Country). That resolved my problem.

     

    Cheers!
    A

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

It seems the location is confusing the mapping.

The map will behave differently if you specify the column to be a City or County etc.

Please change the "Data category" to the correct format: city, state, or something else.

https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey v-juanli-msft 

    Thanks for your reply.

    I am using Latitude and Longitude and not city/state/country names.

    For example Longrech
    In bing maps shows the correct location.

    The values I have in my dataset is -34.87, 150.524 as you can see in the screenshot below for bing.

    However, in PBI the numbers are different.

     

    And my settings

     

    Cheers!
    A

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      In Modeling->Data category

      change columns "Latitude" and "Longitude" to  "Latitude" and "Longitude" type.

       

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-juanli-msft 

        I have done that already. Tried a few categories, that is why it is not showing correctly in the screenshot.

        Anyhow,I found the root cause.

        I have duplicates on the location name --> Same location name but in a different state. So the map is showing an average lat/long for all places with the same name.

        The solution:

        I have created a custom column that will concatenate the (Location, State, Country). That resolved my problem.

         

        Cheers!
        A