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

if(sum(Amount)>=1000000

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

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

I applied above formula ,but the trend line shows bleow

Millions shows down trend and Thousand shows up trend

Thanks

[kaushiknsolanki]

Hi,

     Please close the Post by clicking correct answer.

Regards,

Kaushik Solanki

[#3]

=IF([Student Version] = "no",
[TOTAL SEATS BILLED] * INDEX(SeatSalesFactors[Factor], MATCH([Market] & ":" & [Segment], SeatSalesFactors[Joined Key], 0)),
[TOTAL SEATS BILLED])

if((segement='Post-Secondary') and (market='Emerging') then ((([TOTAL SEATS BILLED])*75)/100)*18),

elseif((segement='Post-Secondary') and (market='Mature') then ((([TOTAL SEATS BILLED])*75)/100)*3),

elseif((segement='Secondary') and (market='Emerging') then ((([TOTAL SEATS BILLED])*75)/100)*15),

elseif((segement='Secondary') and (market='Mature') then ((([TOTAL SEATS BILLED])*75)/100)*5)

else

end if