Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I have columns for latitude and longitude4 in my data for a power bi report but when i drag it to the long and lat section for maps it does not work and just plots 0,0
My coordinates are in this fornat: (see below) but i dont think that is the problem seeing how there is no way to fix this anywas (n o way to convert it)
I attached a picture of the data.
Thanks
Solved! Go to Solution.
Hi @rachel65
Latitude and Longitude fields must be in Decimal Number format. Latitude values should be between -90 and 90, and longitude values should be between -180 and 180. You may try to replace your data as correct value format. Here are the articles for your reference.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks
http://radacad.com/how-to-do-power-bi-mapping-with-latitude-and-longitude-only
Regards,
Cherie
I am having issues getting Power BI to plot the correct Lat and Long for Guam and Mexico. My spreadsheet has the correct Lat and Long for the locations; however, when it plots it on the map the numbers change and plot it incorrectly. I do not have any issues with other locations. Don't know why it is not using the data that I have on my spreadsheet. Can someone please help me figure out a solution? Thank you!
Hi @rachel65
Latitude and Longitude fields must be in Decimal Number format. Latitude values should be between -90 and 90, and longitude values should be between -180 and 180. You may try to replace your data as correct value format. Here are the articles for your reference.
https://docs.microsoft.com/en-us/power-bi/power-bi-map-tips-and-tricks
http://radacad.com/how-to-do-power-bi-mapping-with-latitude-and-longitude-only
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |