Include $ sign on vertical axis

[Anonymous]

Hi,

I've looked at some of the settings for this bar chart I have and didn't find what I was looking for.

How do I include the dollar sign ($) on the vertical axis?  Example, I want to show $5,000,000, $10,000,000

Thank you

[Anil_Babu_Samineni]

Try luck, Change your environment

SET MoneyFormat='$ #.##0,00;-$ #.##0,00';

Or share me your application

[sunny_talwar]

Did you follow this?

You might have to use 5,000,000 instead of 1 here

[Anonymous]

Yes, I put in 5,000,000 for the step.  It worked.  However what's going to happen when my values are small?

Will this work all the time??

[sunny_talwar]

Use a dynamic expression for Static Step. May be something like

Sum(Measure)/5

[Anonymous]

OK, let me play around with this.  I modified my data so the values are much smaller.  This did not work.  The $ disappeared. 

[Anonymous]

This was already in my load script.  Obviously this didn't help either.

[sunny_talwar]

Would you be able to share what you have and may be I can offer some work around

[Anonymous]

Thank you so much.  I will try to create a sample app with this data.  Will upload a bit later today.

[sunny_talwar]

Sounds good

[sunny_talwar]

Try the attached

With no selection:

With Selection

Expression used for static steps

Max(Sales)/5