Forum Discussion

James1965's avatar
James1965
Icon for Helper I rankHelper I
9 years ago
Solved

. 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 ...
  • radpir's avatar
    radpir
    9 years ago

    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's avatar
James1965
Icon for Helper I rankHelper I
9 years ago

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.

Power BI

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

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.