Don't know how to convert this list of latitudes and longitudes to work with Power BI visuals

Miguel de las Nieves 0
Viewed 37

I have a table of cities in argentina with latitudes and longitudes but I can't figure out how to convert them so I can use them with PowerBI maps.

I don't have access to any GIS software nor do I know how to use it.

This is the file: https://docs.google.com/spreadsheets/d/1beGLzNtKQtnqIoaRpTomVQKjg6yJw48nmJ8XXyX2IYI/edit?usp=sharing

enter image description here

localidad_id localidad_nombre localidad_centroide_lat localidad_centroide_lon provincia_id provincia_nombre departamento_id departamento_nombre municipio_id municipio_nombre localidad_censal_id localidad_censal_nombre localidad_categoria
14098270000 SUCO -3343947297 -6483166109 14 Córdoba 14098 Río Cuarto 142588 Suco 14098270 Suco Localidad simple
46119010008 SALICAS -2840762581 -6709615463 46 La Rioja 46119 San Blas de Los Sauces 460119 San Blas de los Sauces 46119010 Salicas - San Blas Entidad

Can someone help me?

Thanks in advance

gis powerbi-desktop powerbi
1 Answers

The GIS software often use integers to speed up calculations. In your case, you must divide the values in localidad_centroide_lat and localidad_centroide_lon by 100000000 to get the actual geo coordinates. After importing your files, add two custom columns, named for example latitude and longitude, as follows:

latitude = [localidad_centroide_lat] / 100000000

and

longitude = [localidad_centroide_lon] / 100000000

Make sure that their data type is Decimal Number and change it if you have to. Then, in the report designer, select each of them and make sure the data category of these fields is correctly set to Latitude and Longitude. Then you can use these new columns in your report to show data on a map:

enter image description here

Andrey Nikolov0
Related