Forum Discussion
Issue with PBI map
I solved the issue adding the city. Thank you.
ZipCode/Country = Location[FullCountry]&","&Location[City]&","&Location[Postal code]
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.
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]I solved the issue adding the city. Thank you.
ZipCode/Country = Location[FullCountry]&","&Location[City]&","&Location[Postal code]