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

radpir's avatar
radpir
Icon for Resolver II rankResolver II
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