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.
I have a calculated column that just takes the difference of today's data and another date. The output of which is the number of days shown in the 2nd column below. I have a divergent conditional format applied, but for some reason, I get different colors even when the values are exactly the same (and the respective dates are also the same).
And the conditional color does not seem to apply consistently down the data series. You can see below that the 58 is blue, then a dark red 54...followed by a dark blue 54...then another dark red 54, etc....
Any idea why this is happening?
Proud to be a Super User!
Hello,
Unfortunately it's not easy to change my file and send to you.
However, I did change the conditional from summing to instead using an average. This seems to have fixed the problem, although I still don't know why it does that if I use "sum".
But thank you!
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |