How to have the $ in front of the number?

[Noor51]

Hello, 

For pick 2 (Highlight Section), how do I format so that there is a $ in front of the number in the graph? Its on Auto formatting.

[Chanty4u]

In the "Format pattern" field, enter the following pattern: '$'#,##0.00.

[Noor51]

That make all the pick have $ in front of them, I only want it for the second pick.

[Sivapriya_d]

Hi @Noor51 ,

Try this
num($(Salesmeasure),'$#,##0') in position 2.


Thanks,

[Noor51]

Hi @Sivapriya_d,

Love the Profile picture. I tried that expression, but it didn't work. 

Best Regards,

[Chanty4u · Accepted solution]

Try something like this but you have to modify your expression accordingly

=Pick(1, Field1, Num(Pick(2, Field2, Field3), '$#,##0.00'), Field4)