Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I'm trying to create a chart with time period as x axis and Left Y axis is Sum(Revenue) in Millions (I used custom format as #,##0 M). So it is displaying Millions on Scale
However on Right Y axis, i use below expression and set Number format as Measure Expression
If(Match(unit, 'Index'),Num(Avg([Home Value]),'#,##0.0'),
If(Match(unit, 'Dollars','Price','Volume','Number'),
if(Sum([Home Value]) > 1000000, num(Sum([Home Value])/1000000, '#,##0.0 M'),
if(Sum([Home Value]) > 1000, num(Sum([Home Value])/1000, '#,##0.0 K'), num(Sum([Home Value]), '#,##0'))),
If(Match(unit, 'Ratio'),Num(Avg([Home Value]),'#,##0.00'),
If(Match(unit, 'Rate'),Num(Avg([Home Value]),'#,##0.0%')
))))
The issue is y Axis scale is showing up as 0, 1K, 2k.... (1K is 1000 and 2k is 2000)
I need to display the scale also as 0, 100 M, 200 M....etc
Is there anyway we can set this option?
Thanks
Satish
Any one?
Any help.
Hi Mike
Any update?
Thanks
Satish
Thanks Mike