Power BI Map Error , displaying in wrong country?

[Anonymous]

Hey are there any known issues with Postcodes picking up wrong on maps? I have double checked the data and source which were all working fine afew hours ago but since loading in again its playing UK postcodes in random countries, which is skewing the visual. 

Appreciate any help on this one. 

[Anonymous · Accepted solution]

Hi @Anonymous 

Ensure that your postcode fields in Power BI Desktop are correctly categorized. In the Data view, select your postcode column, then from the ribbon, select the Column tools tab and set the Data Category to Postal Code. This helps Bing Maps correctly geo-code the data. For more details, please refer to Data categorization in Power BI Desktop.

If you're only using postcodes, consider adding more location data, such as the country or city, to make the location unambiguous. Remember to categorize these new columns appropriately:

Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

Or you can add latitude and longitude values to your semantic model. This data removes any ambiguity and returns results more quickly. Latitude and Longitude fields must be in Decimal Number format, which you can set in the data model.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.