Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Values and variance status.

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"

 

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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