how to round decimal numbers

HI, Anonymous

When you format the data type of one column, the format of the whole column will be the same. So they will be the same format.

But you may try these two ways as reference:

Add a column by this formula:

Column = IF(Table1[Accounts]-INT(Table1[Accounts])>0.4,FORMAT(Table1[Accounts],"0.0"),FORMAT(Table1[Accounts],"0"))

But the data type of this column will be Text.

another use the same formula to add a column, now the data type is Text, then change the data type to Decimal Number

Now it will show the format as what you want in the data view, but in the report visual it will show the same format as others.

Best Regards,

Lin