Inserting dollar signs

Hello rwong2333 

Power BI doesn't natively support conditional formatting of currency symbols only for specific rows (like just the first row and the grand total). But there are a few workarounds you can try

Try calculated measure

Revenue Display =

VAR _Value = SUM('Table'[Revenue])

VAR _RowRank = RANKX(ALLSELECTED('Table'), SUM('Table'[Revenue]),, ASC)

VAR _IsGrandTotal = HASONEFILTER('Table'[YourDimensionColumn]) = FALSE

RETURN

SWITCH(

    TRUE(),

    _RowRank = 1, "$" & FORMAT(_Value, "#,##0"), // First row

    _IsGrandTotal, "$" & FORMAT(_Value, "#,##0"), // Grand Total

    FORMAT(_Value, "#,##0") // Other rows

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.