How to show values in line chart?

[#1]

Hi Team,

How to show values in Million(m) foramt and thousand(k) foramts in line chart

please find the attached doc

Thanks

[Gabriel]

Hi,

First thing I will do is, go to chart properties ->Number tab -> bottom right Thousand Symbol enter TH (or whatever you prefer) -> Million Symbol enter M (or whatever symbol you prefer). Then go to Expression tab then check Values on Data Points. Click OK.

Hope that helps

Regards,

Gabriel

[jagan]

PFA file, hope it helps you.

Regards,

Jagan.

[#4]

Hi jagan,

Iam unable to open qvd file

could you post those steps

thanks

[Gysbert_Wassenaar · Accepted solution]

Something like this:

if(sum(Amount)>=1000000

,num(sum(Amount)/1000000,'#,##0.0 M')

,num(sum(Amount)/1000,'#,##0 K'))

Replace sum(Amount) with the expression you use now.

[jagan]

Hi,

Please find attached file.

Regards,

Jagan.

[#7]

Excellent Wassennar,

Thanks

[#8]

Hi Wassennar,

I applied your formula ,but the trend line shows above

Millions shows down trend and Thousand shows up trend

Thanks