PowerBI map show correct location

[syn_ga]

Hi, i'm trying to show a map with a location, i have the following table:

I'm using just one line with Lat and Long because i'm just testing, i'll do something using Azure Stream Analytics to get this data, even so it'll be just one line. I have a Country, a Long, a Lat and an ID.

I've followed a tutorial, took the values from Google Maps, set the Long and Lat as their respective data fields, put the country on location, but even so my map looks like this:

Someone knows how can i solve this issue?

[asocorro]

Your latitude and longitude values seem out of range.  See this: https://msdn.microsoft.com/en-us/library/aa578799.aspx.

[syn_ga]

Yes i've seen this. In my excel doc the numbers are formated right, like -xx.xxxxx, -yy.yyyyy, but when i upload it to powerBI it changes to -xxxxxxx, -yyyyyyy
Any clue on what i can do? I can't seen to change it to the correct format.

[asocorro · Accepted solution]

Not sure without having the file myself, but how about making sure the data type is a Whole Number (after importing the data) and then creating new columns that divide the numbers by 100000?

[syn_ga]

Turns out i wasn't dividing it by 100000, i've done this and it's working now and my map is showing it. Thank you so much.