Suitable chart when data contains negative and positive values, to avoid empty space any best suitable chart or options. please suggest
Empty space due to negative values in chart
May 12, 2018 11:04 AM
HI Srikanth
I cannot prepare the data here, but just in general.
use
[bar height]
abs(sum([measure value] ))
to show graph
and change the color of negative bar with original value.
[color]
if sum( [measure value])> =0 then "Green" elseif sum( [measure value])<0 then "Red" end
Thanks,
Shin