Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Modelling latitude and longitude

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)

 

 

  • HI Anonymous ,

     

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

     

4 Replies

  • HI Anonymous ,

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey, I solved, thank you!

      • Cedric_DUBOIS's avatar
        Cedric_DUBOIS
        Frequent Visitor

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