how to round decimal numbers

[kan]

Hi In one of my reports I have a column name Accounts whose values  needs to be shown as one point after decimal.

Example 222.573 should be shown as 223.6 .

               222.432 should be shown as 222.4

So I tried in modelling tab in power bi desktop with format as decimal number selected 1 for value after decimal point.so far it is good with values

But issue here is when I have value like 222.032 it is showing as 222.0(because of formatting) which really means 222  So is there a way it can be shown as just 222 instead of 222.0 and remaining values as shown above.

Thanks..

[v-lili6-msft · Accepted solution]

HI, @kan

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

[v-lili6-msft]

hi, @kan

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin