Conditional colour formatting

[Fusilier]

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 dark green? So, if the target is 100 and actual is 200 then dark green etc?

Would that be achieved using rules or field value?

[danextian · Accepted solution]

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

[Fusilier]

Thank you!

[Fusilier2]

How would you adapt this measure to show green if >target, red if < target or yellow if equal to target?

[Syndicate_Admin]

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

[Fusilier]

Sorry, I don;'t understand Spanish. Thanks anyway.

[Syndicate_Admin]

Oh, sorry
Check out this tutorial, it's in English
Bing Vídeos

[Fusilier]

Thank you.

[v-pagayam-msft]

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.