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 trying to format my last ROW where the row label is "Pct Difference" and the rest of the label rows should be formated as CURRENCY. So far I have tried multiple Expressions but unable to get the desired results. Few of the expressions I have tried till now; 1. =IIF(Fields!Child2.Value = "Pct Difference", FormatPercent(Fields!asset_curr.Value, "Dataset1",0), "Default") 2. =IIF(Fields!Child2.Value = "Pct Difference", FormatPercent(Fields!asset_curr.Value, "Dataset1"), '$'#,0.00;('$'#,0.00)) 3. =IIF(Fields!Child2.Value = "Pct Difference", Format(Fields!asset_curr.Value, 0.00%), Format(Fields!asset_curr.Value,'$'#,0.00;('$'#,0.00))) 4. =IIF(Fields!Child2.Value = "Pct Difference", Format(Fields!asset_curr.Value,"P1"),"") This is the expected output I am trying to achieve. Please help Thanks, Ram
