Filled Map wrong country code mapping

[MichalKlos]

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!

[Anonymous]

Hi @MichalKlos 

The Location field of the filled map needs to meet the following requirements. You can try the following types: South Korea/Seoul.

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

Best Regards,

Jayleny

[MichalKlos]

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]

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

[MichalKlos]

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]

Hi @MichalKlos 

Thanks for sharing your solution!

Best Regards,

Jayleny