Latitude and Longitude aggregating and no option to change from "Count of.."

[Mag1cMushr00m]

Hi,

Can you please help investigate this issue? I've tried only selecting records with valid lat lons and have a dataset full of points. Still being picked up as a text it seems despite being formatted as decimal and also categorised as latitude or longitude. Really need this visual for a report.

Thanks, G

[Drew-github]

I'm having the same issue. I know my lat and long are correct as the plot perfectly in other maps. I have set the field to 'Don't summarize' yet it still wants to aggregate by count. Being from New Zealand it doesn't recognise many descriptions of places, so I have to use lat and long. Seems to be a major flaw if you can't use lat and long.

Hopefully you can fix soon.

[guihigashi]

I just experienced this, but instead of Count it was summing the same origins. As a workaround I used a measure like lat_var=MAX(lat) and long_var=MAX(long)

[Drew-github]

Hey @guihigashi , thanks for the reply. I tried using Res_Lat_var = max(Residence_Latitude) and same for longitude, but that didn't work. I think cause it only returns one value (the maximum value) from the whole column. I also tried using the new max measures in the standard Power BI map, and it gave the error "To display latitude and longitude pairs, set the aggregate for Latitude and Longitude to Don't summarize." But I can't see a way of setting a measure to Don't summarize. For the measure I've set the format to Decimal number and the data category to Latitude and Longitude.

So did I follow your suggestion correctly? Or was I meant to include some additional DAX?

[weiweicui]

Not sure what causes PBI to change the dropdown menu, which is not controlled by custom visuals. Could you find other files to have the correct options? Could you try the sample file here? If possible, you may also share a sample of your data so we can take a look. I see a small earth icon near "Work Lat", which means PBI takes it as geo-coord. But in my file, there is a Sigma sign near the field, which means PBI takes it as numbers. This is may be the cause of the missing options. But I am not entirely sure

[aleksvp2017]

Hi guys... did you found a solution?

[Tontonsenpai]

I have similar issue as well when using flow map from power bi if it helps I posted my dataset I used from baywheels and I used the provided longitude and latitude. I tried using don't summarize but it seems to have turn it to a count I am not sure if this is because the longitude and latitude values are too large lyft merge dataset.csv