How to add currency symbol before values in chart

[Rachel_F]

How to add currency symbol before values in chart 

I have generated a graph to show money values as shown below. But I am not able to add currency symbol before the amount on Y-axis. 

The expression I used is

=Dual('$'&Num(Sum(Award Amount)/Pow(10,3*Div(Log10(Fabs(Sum(Award Amount))),3)),'#,##0.0')&' '&Pick(Div(Log10(Fabs(Sum(Award Amount))),3),'K','M','B','T'), Sum(Award Amount)),

how can I modify this to get currency symbol on Y-axis.

[rubenmarin · Accepted solution]

Hi, you can try adding it to the num function: '$#,##0.0'. And use the num function in both dual parameters

[Rachel_F]

Thank you but that did not work for what I was working on.