Conditional Formatting is not working for dates

[Anonymous]

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.

[Anonymous]

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a rank column.

rankk = RANKX('calendar','calendar'[Date])

Then use it in conditional formatting.

Best Regards,

Jay

[Anonymous]

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