How to Manually Map Incorrect Country Codes in Power BI Map Charts?

[Lora_0121]

Hello,
I created a map chart in Power BI using country codes.

However, the country code "SK" (Slovakia) is incorrectly displayed as South Korea.

Is there a way to manually map this correctly?

[rajendraongole1 · Accepted solution]

Hi @Lora_0121 - In your data source, add an additional column that specifies the full country name (e.g., "Slovakia" for "SK").
This helps Power BI distinguish between countries with similar codes.
In Power BI, go to the "Fields" pane, select the newly added country name column.
Under the "Column Tools" ribbon, set the Data Category to "Country/Region".
Use the full country name column instead of the country code ("SK") in your map visualization.

If Power BI continues to misinterpret, consider using Latitude/Longitude coordinates for more precise mapping:

• Add columns for the latitude and longitude of Slovakia.
• Use these values in the map visual to pinpoint the correct location.

[v-priyankata · Accepted solution]

Hi @Lora_0121 ,

We are grateful for your participation in the Microsoft Fabric Community forum

@rajendraongole1  - Thank you for the prompt response!
Additionally, I'd like to offer another piece of insight.

This issue typically arises because Power BI uses a predefined set of country codes, which may not always match the intended mapping in your dataset

• To address your query Please add an extra column to your dataset for the country name and provide the full names of the countries.

• Load the data, then drag the Country Code and Country Name to the Location field in the map visual and drag the Region column to the Legend field.
• In the filter pane, select the country as per your requirements.

Please refer to the snapshot below for your reference:

If you found this helpful, kindly mark it as the solution to assist others. A thumbs-up or kudos would be greatly appreciated!

Best Regards,
Priyanka.

[v-priyankata]

Hi @Lora_0121 , Just checking in as we haven’t received an update from you regarding our last response. Were you able to resolve the issue?

If our solution was helpful, please mark it as Accept Answer and click Yes to confirm.

Feel free to let us know if you have any further questions—we’re here to help!

Thank you for being a part of the Microsoft Fabric Community Forum!

[rajendraongole1 · Accepted solution]

Hi @Lora_0121 - In your data source, add an additional column that specifies the full country name (e.g., "Slovakia" for "SK").
This helps Power BI distinguish between countries with similar codes.
In Power BI, go to the "Fields" pane, select the newly added country name column.
Under the "Column Tools" ribbon, set the Data Category to "Country/Region".
Use the full country name column instead of the country code ("SK") in your map visualization.

If Power BI continues to misinterpret, consider using Latitude/Longitude coordinates for more precise mapping:

• Add columns for the latitude and longitude of Slovakia.
• Use these values in the map visual to pinpoint the correct location.