Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional formatting doesn't work for all cells

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

 

  • 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.

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      Thanks. Now I realized that I switched two columns.

      What a s...d mistake 😉

       

      Thanks