Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Map visualization with country codes

Hi,   I'm trying to display on a map the number of lines of data linked to a particular country code. I am using the ISO Alpha 2 codes (France = FR). I put my geoloc column in the location field, ...
  • Anonymous's avatar
    Anonymous
    10 years ago

    I want to give an update on how I solved this issue.

     

    I used an Excel file that maps country codes to latitudes and longitudes, and imported it into my report.

    I then just had to link the "Location" column from my data with the "Country Code" column of my Excel file, and use Latitude and Longitude on a map visualisation for it to work.

     

    Thanks :smileyhappy:

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi jhyot,

 

In your scenario, it seems that some ISO Alpha 2 codes have wrong mapping to real countries. To correct correspondence, we can create a new query and define the mapping, then merge this query with the original query. For more information, please refer to this article: Mappings in Power BI.

 

If you have any question, please feel free to ask.

 

Best regards,
Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    I want to give an update on how I solved this issue.

     

    I used an Excel file that maps country codes to latitudes and longitudes, and imported it into my report.

    I then just had to link the "Location" column from my data with the "Country Code" column of my Excel file, and use Latitude and Longitude on a map visualisation for it to work.

     

    Thanks :smileyhappy:

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      Hi jhyot,

       

      Glad to hear that your issue had been solved by yourself. Thank you for your sharing which will help other forum members who have the similar issue. :smileyhappy:

       

      Best Regards,
      Qiuyun Yu