Colouring KPI Chart

[JOhn Cleary]

Hi All,

Would anyone know if its possible to color the KPI visualisation based on its relationship to the comparitive value

For example - it the value for today is greater than yesterday then the KPI visualisation is red but if less than yesterday its green.

Thanks in advance.

John

[Sean Riley]

If you lookin the Colors > Columns selector under 'Axis Values' you will see 2 options:

 

Value axis values

Comparitive axis values

 

If you look at the expression for both of those (right click and select "Custom Expression") you will see those translate to (respectively):

 

THEN [Y.FinalValue]

THEN [Comparative.FinalValue]

 

So you can modify that Color by expression to create the "delta" coloring scheme you want. For example:

 

THEN

case

when ([Y.FinalValue] - [Comparative.FinalValue])0 then "green"

end

[JOhn Cleary]

Thanks Sean

[Grazia Palmisano]

is there a way to color only the text of comparative value and not all the kpi box

 

Thank you