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
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
Become a Viz Whiz on the Forums! Support the Community and master Tableau.