A client needs a map visualization showing sales per city but the dataset lacks latitude longitude coordinates How can you ensure accurate city placement in Power BI

Question

A client wants a map visualization showing sales per city, but their dataset only contains city names without latitude/longitude coordinates. How can you ensure Power BI accurately places the cities on the map?
You are working on a Power BI report that includes a map visualization for sales performance by city. However, the dataset lacks latitude and longitude coordinates, which can lead to incorrect placements. What are the best practices for ensuring Power BI accurately maps city locations, such as enriching the dataset with country information or using external sources for geocoding?

Answer 1

Accurate city placement in Power BI maps by following these best practices in placement:

Include Country/State Information: ADDS Country and State/Province columns when city names are ambiguous in Power BI geocoding for improved accuracy.

Utilize Data Categorization: Set the 'City' column's data category as Place and 'Country' as Country in Model View for Power BI to interpret the location data correctly.

Enriched Data with Co-'ordinates: In the Case of Accuracy Issues, Latitude and Longitude Data should be sought outside in OpenStreetMap or Google Maps API, for example, with Location Coordinates Used in Map or Azure Maps Visuals.