Dynamic Color Expression

[#1]

Hi,

Following is the table in my Data Model which may change this value at any time.

I'm using Bar Chart having multiple bars in which i want to use this range of color.

But i cant do it hardcore.because it may change at any time so i want to use variable.

How can i implement it at Background Expression? How implement it in Varibale?

Color	Value from	Value to
Green	0	5
Amber	6	95
Red	96	100

Expression for Bar Chart are as follow

sum(total_exception)/sum(total_qty)*100

[rubenmarin]

Hi sandy, maybe you can use this background expression:

If([ExpressionName]<=Only({<Color={'Green'}>} [Value to]), Green(),

If([ExpressionName]>=Only({<Color={'Red'}>} [Value from]), Red(), Yellow()))

Or create a variable with that content and this bg expression:

$(VariableName)

Change the Green(), Red(), Yellow() for the RGB() you want, and [ExpressionName] to your current expression name, if the name is also an expression you can use [$(CopyNameExpressionHere)]

[MarcoWedel]

Hi,

maybe one solution using variables for the 2 limits could be:

hope this helps

regards

Marco