Forum Discussion
Custom Number Formatting in Power BI Report Builder
Hi Team, I am really frustrated and struggling to make one of the CHILD group numbers to be formatted as % while the rest of all should be in CURRENCY [$]. Here is the example where I am tryi...
Where are you setting this expression? If you just right click on the cell and edit the Expression you are setting the expression on the value property, But you can use expressions in almost all the properties in Report Builder. I woud suggest trying to set the Format property of the cell using an expression something like the following:
=IIF(Fields!Child2.Value = "Pct Difference", "0,00%;-0.00%" , "$#,0.00;($#,0.00)")