Conditional formatting doesn't work for all cells

[Anonymous]

Hello,

If the similar topis has been opened in the past, sorry that I opened a new one.

I have a problem with conditional formatting. 

I am quite new in Power BI so I will be gratefull for any clues. 

Values type: Whole number

Thank you in advance

[jdbuchanan71 · Accepted solution]

@Anonymous 

If you pull your field [DateDIF] into the visual and set it to SUM what does it show for that second row?  If there are 3 rows with a value of 21 then the SUM would be 63 and that is outside the range.  Just a thought.

[Anonymous]

Thanks. Now I realized that I switched two columns.

What a s...d mistake 😉

Thanks