Data type rounding problem

[Anonymous]

Greetings everyone,

I am back with a new problem that im trying to solve.

So I created a report that is based on many columns, text columns, numbers columns.

I have a column that is with numbers (for example 100, 200, 101.6). When I add this column to a table in the powerbi report, those numbers that has decimals are being round up, for example 101.6 is rounded to 102. I tried to change the data type in modeling to text, whole number, decimal number, fixed decimal number, also set a decimal or two but but all that appears are 1 or two zeros after the rounded number.

The columns doesn't do any kind of sum in the powerbi report.

I also changed the data type of the column in the excel sheet and I get the same result except that when I change in excel from dot (101.6) to comma (101,6) the number appears as 1016 in the powerbi report. 

Any ideas that would help me out? Thank you very much for your time and help.

[Anonymous]

Edit: I separated the numbers with decimals in another column and now they show up ok, but the point is that now I have 3 columns instead of 2.

It would have been great if those numbers with decimals could be showed up in the same column with the whole numbers too.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

I cannot reproduce the same issue.Please check the data type and use Decimal Number.Please check if below post could help.

https://social.technet.microsoft.com/Forums/en-US/282ccbca-01ea-4771-a4c2-0c0c1c378bc8/decimal-places-rounded-up-when-trying-to-load-excel-file-using-power-query?forum=powerquery

Regards,