Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional Formatting is not working for dates

Gradient is not working for dates from MAX to MIN, anyone knows why? I want to  color based on the latest date with a dark color until the oldest one with a soft color.

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Create a rank column.

    rankk = RANKX('calendar','calendar'[Date])
    Then use it in conditional formatting.

     

    Best Regards,

    Jay

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Gradient for date type can only use count value as basic.

    You will need to create an index or a rank column, and use this column as basic value of Gradient.

     

    Best Regards,

    Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jay, how can I do that? I'm not fully understanding 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

       

      Create a rank column.

      rankk = RANKX('calendar','calendar'[Date])
      Then use it in conditional formatting.

       

      Best Regards,

      Jay