Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Hi @bix,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |