Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data type rounding problem

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.

2 Replies