Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
my color Expression if(SUM({<[Account]={'Product B'}>}VALUE)<0, red(),black())
Please can you help me, why the following negative values are black colored, although my Expression is defined in red?
And how it is possible to color the line in a different color? This is my Plan-Line. This color alters if I use the expression above. It is possible?
Thank you!
What is the expression that you use for your chart? Do you have other set analysis that ignore some other selections when plotting the chart?
You have another set that force the black color, it may be in the chart parameter.
Try to put only that expression in a new table.
No I have no further Filters or other selections.
Please can you explain where I find this setting? In Colors I can set the black color but I want to set the line in red
What is your chart expression?
Which one is represented for the bar? actual? May be try this
if(SUM({<[Account]={'Product B'},SALES={'actual amount'}>}VALUE)<0, red(),black())
where you did put your color expression. have you another color expressions?
in multi color I have no black possible