Forum Discussion
How to round negative values
The problem is in the Query view it is rounding up to 2 decimal values. But as soon as I am reverting back to report view its is not getting round up..Strange isn't it.
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 .
