Forum Discussion
Solved
Conditional colour formatting
Is it possible to create a conditional colour format based on % difference from a target value to change the background colour of a card visual? For example if a value is 50% higher than target show...
Hi Fusilier
Create a measure similar to below:
VAR _target = [target measure or target value] VAR _actual = [actual measure] VAR _diff = _actual - _target VAR _pct = DIVIDE ( _diff, _target ) RETURN SWITCH ( TRUE (), _pct > 0.5, "green", "red" )Use this to conditionally format a card's background using field value
Thank you.
Hi Fusilier ,
Thank you danextian and Syndicate_Admin for the helpful insights!
I wanted to follow up on the previous suggestions regarding conditional formatting . We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there is anything else we can do to help.
Thank you.
Regards,
Pallavi.