Forum Discussion
PowerBI map show correct location
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?
Your latitude and longitude values seem out of range. See this: https://msdn.microsoft.com/en-us/library/aa578799.aspx.
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.
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?
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.