colour measure by conditional expression question

[ioannagr]

Hello everyone.

I have a set a limit by a conditional expression to a measure. Over this limit the colour is green, under it is red.

When the measure is zero it's still green coloured!

How do i change it to be a neutral colour? Say blue?

[GaryGiles]

It depends on what type of chart object you are using and where you setting your limit by conditional expression.  If you are using a basic if statement where you can specify a color, why not:

if(expression=0,blue(),if(expression<0,red(),green())

[ioannagr]

Hello, yes my bad, I forgot to mention, It's a simple KPI so maybe the above doesn't work? What do you suggest @GaryGiles ?

[GaryGiles]

You can set multiple limits in the KPI Conditional colors.  Have 2 limits.  One at -.000001 and the other at .000001 (or whatever preciseness your data requires) .  You will have an option to set 3 colors.  Left Red, middle Blue and right green.  

BTW, this can be a little tricky.  You may to start at -1 and 1 so that you can easily distinguish between the two limits and then change the values to -.000001 and .000001.