Forum Discussion
How to round negative values
As you guys can see I have already applied Round up to 2 decimal place for Actual profit columns. But it seems that for some negative decimal values it is not applying and for some it is wor...
This is the formulae Power BI is using
= Table.TransformColumns(#"Changed Type2",{{"Actual Profit", each Number.Round(_, 2), type number}})
Actual Profit is the Column Name.
Right, so after you load it from the query when you're back in the report, check the formatting in the Modeling tab.
The formatting ribbon is disable for me as you can see in the screen shot
You have to select the column.
I did that.
Its decimal. And I got the solution. Actually in the data query view you can change the formatting of the column . I don't understand why the formulae I have used for the column is not overriding everything else. What is the purpose of the making query level changes when we have to manually change the formatting again .
