World map issue.

[Alexand3rBr]

Hey, has anyone had an issue when they import a excel sheet, it automatically makes formulas for the Latitude and Longitude fields? When ever I try to add the sheet in, it takes the two columns (decimal field) and creates a formula; and when I add the Latitutde and Longitude in, there is no way to remove the sum (don't summarize)... This is a problem because it prevents me from displaying the different locations of all the names that are placed into the map. Did I miss something?

[Sean]

@Alexand3rBr try placing a field in the in the Size field (you can also then use the Location field)

Look at my answer here (the aggregation of Lat and Long is not preventing you from plotting the locations)

http://community.powerbi.com/t5/Desktop/How-to-color-code-different-GPS-coordinates-by-category/m-p/...

[Alexand3rBr · Accepted solution]

Hello,

Thank you for the solution, however I found a way to fix it too. You can go to the longitude and latitude fields, and change the field type to Count (Distinct), then you can select the "don't summarize" option in that dropdown menu. I did this for Longitude and Latitude which fixed the issue and allowed them to be rendered.

-Alex b.