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:

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Anonymous This tips and tricks page may help, but in general the power bi maps use Bing maps/geocoding. It isn't as intuitive as other mapping tools, so you may need to figure out the best way to alter the data on the backend so it recognizes the locations accurately.