Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

conditional formating - strange behavior

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?  

 

2 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    Can you share your pbix so we can reproduce the issue? Please remove sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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!