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,
How can we use conditional formatting with negative values? I have year on year percentage change which can be either positive or negative. Either I'm acting really dumb or just having a bad day, but I can't for the life of me work out the rules for negative values?
Any help would be much appreciated.
Cheers
Solved! Go to Solution.
You can format by rule with negative number (rather than percentage) to format the yoy declines. -1 = -100%:
thank you for the solution i was loosing my mind!!!
You can format by rule with negative number (rather than percentage) to format the yoy declines. -1 = -100%:
Thank you so much ... I'm just having one of those bad hair days where I couldn't work the stupid thing out.
Cheers
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |