Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

Conditional Formatting based on DATE and IS BLANK

I currently have a rule in place that if a data point is BLANK, then shade the table box RED.  I'd like to add another rule based on Class Start date.  If the class  start date is    MORE Than 7 days AGO, then shade red, if within the last 7 days, yellow.    

 

I'd like to combien both of those rules if blank and then the red/yellow combo

 

Please see screen shot.

Need Help

8 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi jcastr02 ,

     

    We can create a measure and set it as Field Value of Condition Format.

     

    ColorFormat =
IF (
    TODAY () - MAX ( 'Table'[Class Start Date] ) <= 7,
    IF ( ISBLANK ( [YourMeasure] ), "#FFFF00" ),
    IF ( ISBLANK ( [YourMeasure] ), "#FF0000" )
)

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      6 years ago

      v-lid-msft 

       

      What should I put for "Your Measure" would it be for the point value for each of the modules, meaning I would have create several quick measures?         I never created a measure for the ISBLANK rule - just did a rule in conditional formatting.  

       

      see screen shot.