Jump to content

Colouring KPI Chart

JOhn Cleary

Recommended Posts

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.


Link to comment
Share on other sites

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:




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


Link to comment
Share on other sites

  • 3 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...