How to display money as abbreviated number?

[nlopedebarrios]

I'd like to display money representing numbers the same way de Automatic format does, for example:

(using . as thousands separator and , as decimal)

• 1.250.000 as $ 1,25M
• 429.300 as $ 429,30K
• 1.575.000.000 as $ 1.575M (NOT $ 1,57G)

is this possible?

[QFabian · Accepted solution]

Hi @nlopedebarrios , here an option for what you want :

Example data : 

Data:
Load * INLINE [
Type, Amount
A, 1250000
B, 429300
C, 1575000000
];

Viz :

Expression :

'$ ' & if(Sum(Amount) < 1000000,
num(Sum(Amount) / 1000, '#.##0,00') & ' K',
if(Sum(Amount) < 1000000000,
num(Sum(Amount) / 1000000, '#.##0,00') & ' M',
num(Sum(Amount) / 1000000, '#.##0') & ' M'))

[nlopedebarrios]

Thank you @QFabian !

[nlopedebarrios]

Hi again, @QFabian, the solution works in a KPI, but when I try to use it in a bar o timeline chart, I'm getting this error:

The graph is not displayed because it only contains undefined values

 I've used the expression to create a master measure.