Forum Discussion
. as thousand separator = wrong
Hi,
I am a swedesh user. I use csv-files as input, with data such as 12.34, 0.0023, 15.60, 0.0015 etc.
Power BI, efter change the type to decimal number, give me 1234, 23 ... It treads "." inte a decimal point. Could you help me?
Thanks.
hi there,
i think you can change the locale to English (United States).
or you can try replacing the dot (.) with a comma (,) before converting the values to decimal numbers.
this should do the trick.
hope this works for you,
radpir
5 Replies
Can you please post your sample file if possible to see exactly what is happning behind the scene.
Ok.
The data files (many sensor data) is like,
Date Time,Battery[V],Temperature,Humidity, An_1,An_2,DIG_010,DIG_010_T,DIG_011,DIG_011_T,DIG_012,DIG_012_T,DIG_013,DIG_013_T,DIG_014,DIG_014_T,
2016/11/03 14:03:50,12.1,19.3,N.C.,-36.849,399.703,0.15596,20.84561,-0.06102,20.68701,0.08798,20.92682,0.11082,20.77658,0.14069,20.78555,
After change the type to decimal nummber (I can not export data, can you see the image below?),
(date_Time), 122, 193, ..., -36849, 399703, 15596, -6102, 2068701, 8798, 2092682, 11082 ...
I can think to change the settning from "Swedish" to "English". But which language is suitble for me?
Regards.
You can see in my screenshot that I don't have any problem converting your sample data in decimal numbers.
I have splitted the column by comma separator and converted the data type of resulting columns into decimal numbers.
