Forum Discussion
set dot as decimal separator
I have a ssv file having swedish street name and longtitude and latitde Now even able to lode correctly in to power bi I double check if i use subline I can see the long, lat having dot as deci...
Hi, I finally find a way to solve it.
1. change the excel load preference
2. change the local file 'regional setting ' only this work, not swedish or english
On your report (not in the query editor), check under Modeling Tab, what is the Data Type and Format for this field. Looks like its set to Currency. Change it to decimal number. And additionally, you can change the Data category as well to Latitude or Longitude.