Modelling latitude and longitude

[IgorAM]

Hi guys,

I have a data with two columns, lat and long, both of them came like this XX.XXXX (text format). I change to decimal number at power query, after this, change the resume for "Not resume" and categorize like latitude and longitude.

Now I'm trying to put this data at a map visual, but does not work, because the visual is trying to calculate average, like the image, and I can not change for "not resume" here, because there is no option.

(sorry, the picture is in portuguese, because I'm from Brazil)

[Pragati11 · Accepted solution]

HI @IgorAM ,

Can you share some sample data here please with the Latitude & Longitude values you have?

[IgorAM]

Hey, I solved, thank you!

[Cedric_DUBOIS]

Hi @IgorAM : How do you solve it ? I got the same issue ... Thanks !

[IgorAM]

Of course, where is the option to attach? i'm trying to drag, but it's saying .xlsx and .pbix is not supported.