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%, ac...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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