So I am using a quick table calculation to show a difference from a measure - showing this on a bar graph. Is there a way to get all of the negative values to be in red and the positive values in blue or black bars? I drag the quick calculation onto the color shelf, but that makes the bars disappear. Thanks in advance!
By setting the using the calculation in another calculated field similar to the following should work:
if [Calculation1]<0 then 'red'
elseif [Calculation1]>0 then 'black' end
Place this on the color shelf. Make sure that is being computed the same way that Calculation1 on the view is being computed.
Hope this helps!