MichalKlos's avatar
MichalKlos
New Member
1 year ago
Status:
Done

Filled Map wrong country code mapping

Hi Everybody,

I'm using a Filled Map to show values by country code.

Unfortunately I've noticed that it's not following the codes properly - map seems to confuse country code SK with South Korea which is wrong.

 

SK = Slovakia, KR = South Korea:

See: https://www.iso.org/obp/ui/#search and search for both countries.

Is there a way to process a bugfix ?

 

thank you!

5 Comments

  • Hi, thank you for quick reply.

     

    It works correctly for every other country ISO 2-letter code (such as US, DE, FR, JP ... ).

     

    Still Country code mapping is wrong when I try to highlight entire country Slovakia. Map shows SK as Korea and it should Slovakia. ( https://countrycode.org/slovakia )

     

    I tried SK/Bratislava in the Country field but it is not recognized.

     

    Maybe I can apply a workaround? If SK is seen (incorrectly) as Korea, then what is the utilized (currently wrong) ISO code for Slovakia that I could temporarily use before it's fixed?

     

    Is there a list of accepted 2-letter country codes ?

     

    Kind Regards

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MichalKlos 


    As stated in the following documentation: 

    Map data can be ambiguous. When you supply Bing with only one column of data, such as for the city name, Bing might not distinguish data for one city location from another of the same name.If your semantic model already contains latitude and longitude data, Power BI has special fields to help make the map data unambiguous. You can drag the field that contains your latitude data onto the Latitude section on the Visualizations > Build visual pane. You can use this same approach for your longitude data.

     

    Create and use filled maps (choropleth maps) in Power BI - Power BI | Microsoft Learn.

     

     

    You can place the corresponding latitude and longitude in the visual so that it is correctly recognized.

     

     

     

     

     

    Best Regards,

    Jayleny

  • Thanks a lot. I thought that the codes mapping in the map is somehow hardcoded and can be fixed, but if it's Bing search-driven solution, then it's a different story. However, I've actually found a more simple solution (yet still a workaround). I created a column that replaces "SK" by "Slovakia" and linked that column to the map instead the original one. It's correct now. Kind regards 🙂
  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MichalKlos 

    Thanks for sharing your solution!


     

     

    Best Regards,

    Jayleny