shorting the number

[manu1512]

Hi all,

I want to convert the my expression like 30000 into 30k,500000 into 50m in Bar Chart.Please let me know step by step.

Regards

Manu

[Anonymous]

in expression...

num(sum(dimenson/1000), '###K')

[Anonymous]

=If(sum(<your measure>)/1000000 > 1 //check if more than million

,Num(sum(<your measure>)/1000000 ,'#,##0M') // in million

, Num(sum(<your measure>)/1000 ,'#,##0K')) // in K

[Siva_Sankar]

Hi Manu,

Try the below expression, replace your YourExpressionHere with your measure

=If(sum(YourExpressionHere)/1000000000 > 1,Num(sum(YourExpressionHere)/1000000000,'$#,###B'), Num(sum(YourExpressionHere)/1000000,'$#,###M'))

-Siva

[Anonymous]

Hi,

Alternatively, Please see the below image: