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...
Hi,
First, try ask in another formum: DAX commands and tips
Second, I think is not good idea use multiple measures/scales in single column, better is design it with multiple measure columns (like Count, Amount, AmountDifference, AmountDifferencePct), but I do not know story behind it.
But, in case when need format single column by different way you can use if, switch and format function. Also depends if you need row level value, or measure. If row level value it is easy
IIF(Fields!Child2.Value = "Pct Difference", Format(Fields!asset_curr.Value, "0.00%"), Format(Fields!asset_curr.Value,"\$#,0.00"))
If it is measure you can try:
Solved: Re: DAX expression using specific field - Microsoft Power BI Community