Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I make the bars pointing to the left (negative value) to be colored as RED rather than all bars are blue in this bar chart?
Hi Ronnie
Go to your expression and write the Condition eg. Sum(Value)
Expand the Expression and on Background Color write the condition if(Sum(Value)>=0,Blue(),Red())
It will work for you.
See the Snapshots and Attachment.
Regards
Aviral Nag
Click on the + in front of the expression, select Background Color and enter an expression in the Definition field to calculate the color: =if(sum(Amount)<0, red())
Hi Ronnie
Go to your expression and write the Condition eg. Sum(Value)
Expand the Expression and on Background Color write the condition if(Sum(Value)>=0,Blue(),Red())
It will work for you.
See the Snapshots and Attachment.
Regards
Aviral Nag
Thank you both, I got the color now. Works like charm.
Now, if only I could get those long numbers shorten into millions, that would be perfect. Any idea?
num(sum(Amount)/1000000, '#,##0 M')
It works! Thank you Gysbert.