Values and variance status.

[Anonymous]

Hi fellows, 

When there is “ahead” progress (e.g. planned= 50%, actual= 80%), the difference (30%) must be shown with positive (+) sign. And when there is “behind” progress (e.g. planned= 80%, actual= 25%), the difference (55%) must be shown with negative (-) sign.

And

difference between (0-19% goes Green), (20-39% goes Yellow), and (40-100% goes Red).

Currently I am using "Cards with States by OKViz"

[v-yulgu-msft]

Hi @Anonymous,

If you add "planned" to Target section and place "actual" to Measure section of this visual, the difference value will be automatically displayed with "+"/"-" depending on whether it is a positive or negative value. But, to set conditional color for variance based on specific value range (0-19% goes Green, 20-39% goes Yellow, and 40-100% goes Red) is not avaiable now. You could submit idea here.

Best regards,

Yuliana Gu