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
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.
