. as thousand separator = wrong

[James1965]

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. 

[BhaveshPatel]

Can you please post your sample file if possible to see exactly what is happning behind the scene.

[James1965]

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.

[radpir · Accepted solution]

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

[James1965]

Hi @radpir,

It is real helpful! Tahnks! 

@BhaveshPatel, Thnak you!

[BhaveshPatel]

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.