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
- AnonymousNot applicable
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
- MichalKlosNew Member
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
- AnonymousNot 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
- MichalKlosNew MemberThanks 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 🙂
- AnonymousNot applicable