Forum Discussion
Conditional colour formatting
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
Good afternoon, I hope you are well,
If I misunderstood, here's what you need
Video Help = Bing Videos
Measurements = 📊 Visual Pro Card: From Simple to Sensational in Just 4-5 Minutes - Google Docs
I hope it serves you,
Best regards
Sorry, I don;'t understand Spanish. Thanks anyway.
Oh, sorry
Check out this tutorial, it's in English
Bing VÃdeosThank 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.