clustered column chart settings

[Anonymous]

Hi,

Using the clustered column chart visual as follows:

y axis shows M which I know is short for Millions. i.e. 0M, 1M, 2M, 3M, as well as -3M, -2M, -1M

Question:

1- 

How can I convert smaller numbers to show 100K, 200K, etc. instead of 0.1M, 0.2M, etc.?

2-

How can I add a label to the axis i.e. $  ?

Thank you

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

For your first question, the units of y axis must be the same(either thousands or millions).
For your second question, you can change the format of data to currency.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.