Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a measure called "Total Value".
I want the background to turn red if "Total Value" <0, Green otherwise.
Which expression should I include in the properties of the measure, corresponding to the "Background color expression"?
Thanks
If(Expression <0,Red(),Green())
Replace Expression with your expression
Red() and Green() are standard color functions. You can also use RGB() or ARGB() for customized colors
If you showing in chart, Then Try this
Then in properties of the expression or dimension click on + symbol background color you can use
=if(Total Value field <0,Red(),Green())