Changing Monetary Values to Numerical Abbreviations on X-Axis

[snightengale]

Hi, 

I'm building a scatter plot and have large values of money on the X-axis. I want to change those values from being $20,000,000,000 to $20B but can't seem to get that to work.

Measure:  Sum({<ModelDiscretionaryAcctFlag={'N'}>} AccountValue)

Number formatting: Money, $#,##0;-$#,##0

Tried using Number formatting: Custom Format: $#,##0.0a

Neither seems to give me what I want. Any thoughts? 

* 

[priscilarubim]

Hi @snightengale.

First, I would like to ask whether all the numbers are in the billions scale. If that is the case, you can write the formatting directly in the measure expression, but leave the chart number formatting set to Auto.

For example:

Num(
    Sum({<ModelDiscretionaryAcctFlag={'N'}>} AccountValue) / 1000000000,
    '$#,##0B;-$#,##0B'
)

This scales the value to billions and displays values like:

20,000,000,000 -> $20B
69,000,000,000 -> $69B

Hope this helps 🙂