Table rounding up values?

[BarryFletcher]

Hi all,

I have a power query with a value as shown below....

When I import this column / values to my power bi table it is setting all the value below 0 (0.4 etc) as 0 and not totalling them up as required? Even thought he column is set to decimla and 2 decimal places etc?

[ryan_mayu · Accepted solution]

Usually after you import data, PQ will change the data type automatically.

you can try to delete the change type step to see if the data is correct.