Problem with Latitude and longitude in Map visual

[mohsin-raza]

Hello : 

I have a data having decimal values of latitude and longitude given below.

60.207235	16.309513
60.240608	16.43176

when i try to use in Map visual 

How can i solve this problem?

regards

[Brunner_BI · Accepted solution]

Try dividing the latitutude / longitude in a DAX measures and see if it gives you the correct result 3.691...

[mohsin-raza]

Latitud	Longitud	Latitud decimal	Longitud decimal
60° 8' 33"	16° 9' 21"	60.142557	16.156103
60° 8' 48"	16° 10' 14"	60.14686	16.170622
60° 8' 29"	16° 11' 12"	60.141407	16.186678
60° 17' 5"	16° 24' 8"	60.28482	16.402248
60° 7' 31"	16° 12' 33"	60.125507	16.20943
60° 9' 51"	16° 10' 34"	60.16421	16.176113
60° 9' 6"	16° 18' 45"	60.151703	16.312752

@Brunner_BI  How the Dax can help me to mark coordinates points on Map from the above dataset?  

[Brunner_BI]

Make sure to use the decimal values (exactly this data type) and when you left-click on the column (in the fields pane on the very right) make sure to tag the columns (in data category) as "longitude" and "latitude" maybe it works then...

[mohsin-raza]

@Brunner_BI  thanks for reply

 I  converted latitude and longitude values into decimal by using  calculated column.there were some values creating bugs in the dataset . This help and I can visualiz the points on Map. 

I will try with DAX

thanks again ! 

[Brunner_BI]

There are two dots "." in your decimals? Are you sure this is a proper decimal value?

[mohsin-raza]

60.207235

16.309513

@Brunner_BI  No 

Latitude= 60.207235 and Longitude=16.309513

same with other decimal number