Forum Discussion
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-msftMicrosoft 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