Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

BI Maps Not Returning Correct Location

I have a data set that is behaving strangely in PowerBI.  When I use the map in BI I get the wrong location but when I type the same value in Bing Maps I get the correct one using the same format.  Any help is appreciated.  

 

  This is the typed in value in Bing.com/Maps

Location in BI  This is the location in BI

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello,

     

    something you can do is to concat the country name and the city name in order to place them correctly in the map. To do it create a new column: country_city = country & " " & city.

     

    There are other ways to do it, bu this is a simple one.

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Based on my test, it works fine on my side, colud you please what the version of your Power BI Desktop?

     

     

     

    Please don't have any Confidential Information or Real data in your reply, such as User ID and Session ID.

     


    BTW, pbix as attached.

     

    Best regards,

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