Numerical Abbreviation on stacked bar chart

[NitinK7]

Hi Expert,

I try to create custom Numerical Abbreviation and try to use in stacked bar chart. then 'K' for thousand and 'M' for million are not showing . if use normal expression like Sum(v_DailyRunrate) and use number formatting auto then result showing 2 decimal point and not showing '$' symbol. this is problem only in stacked bar chart .

I want to show if Sum(v_DailyRunrate)>1000 then   $ 34.6 K else $7.4 M rather than simple number

see below exp.

if( $(v_DailyRunrate)>1000 and $(v_DailyRunrate)<1000000,
Num($(v_DailyRunrate)/1000,'$#,##0.0 K'),Num($(v_DailyRunrate)/1000000,'$#,##0.0 M'))

thanks in advance.