Issue with PBI map

[Daniel1993]

Hi!

I have read several posts about PBI map, but have not found the right solution. So hopefully someone can help me.

I have a table with locations, including a column with zip code (postal code) and a column with country (1 with abbreviation of 3 digits and 1 with fully country name).

In most cases, if I use ''country'' and ''zip code'' in  ''Location'', the bubbles are correct except for 2 cases:

The locations of Luxembourg. The zipcodes are located in the Netherlands instead of Luxembourg..

One bubble of Czech Republic is located in France/Belgium..

It is set up like below. I also tried to create a new columns and tried to use them as post code

[Country Code] & " , " & [Post Code] or [Post Code] & " ," & [Country].. same output.

Country/Postal Code do also have the right data category

Hope someone can help me out 🙂

[Anonymous]

Hi @Daniel1993 ，

It's not clear what your data source is. If it is Excel and you want to convert ZIP Code to Latitude and Longitude

How to Convert ZIP Code to Latitude and Longitude in Excel

Hope this helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[danextian]

Power BI maps based on location name is kind of a hit or miss. Your best best is to specify the exact location using the geo coordinates - latitude and longitude.

[rajendraongole1]

Hi @Daniel1993 -By default, Power BI relies on Bing Maps for geocoding, and sometimes ambiguities in location data (like shared or similar postal codes across countries) lead to incorrect placements.

you can create a calculated column in Power BI that concatenates the country name and zip code.

eg: LocationKey = [FullCountry] & " " & [ZipCode]

Use this column in the "Location" field of your map visual. This makes the geocoding process more explicit.

you can also configure that with category label

If the issue still exist, consider using a custom map visual like ArcGIS or Shape Map in Power BI, where you can upload custom boundary data or shape files for precise control over location plotting.

Hope this details helps.

[Daniel1993 · Accepted solution]

I solved the issue adding the city. Thank you.

ZipCode/Country = Location[FullCountry]&","&Location[City]&","&Location[Postal code]

[Daniel1993]

Hi thanks for the respons! I tried to create the calculated column, but I do not see any bubbles based on that.  I used: 

ZipCode/Country = Location[FullCountry]&","&Location[Postal code]