Question

You are building a report that plots store locations on a map. The dataset contains numeric Latitude and Longitude columns, but Power BI keeps aggregating them and placing all points near the center of the map instead of at their correct locations. What is the most appropriate action to fix the placement?

Accepted Answer

Set the Data category of the Latitude and Longitude columns to Latitude and Longitude respectively, and ensure they are not summarized on the map.

Answer

Change the Latitude and Longitude columns to text data type so they are treated as discrete values.

Answer

Concatenate Latitude and Longitude into a single Location column and place it in the map's Location field.

Answer

Enable Auto-detect locations in the map's format pane and remove the Latitude and Longitude fields.