Forum Discussion
Conditional formatting with dates not working
Hi Anonymous ,
Here's my solution.
Create a measure to convert the dates to numbers.
Measure = VALUE(FORMAT(MAX('Table'[Date]),"YYYYMMDD"))Set up the conditional formatting for dates.
Select the measure field.
Click OK.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Pat, thank you taking the time to answer me, but I´m not understanding quit good the solution (and also I don´t see the gradent in the example you gave me). I want the most recent date to be like in dark blue, and keep gradienting into the oldest date to be pale blue, and it´s happening like the pic I uploaded. 😞
Hi Anonymous ,
Here's my solution.
Create a measure to convert the dates to numbers.
Measure = VALUE(FORMAT(MAX('Table'[Date]),"YYYYMMDD"))
Set up the conditional formatting for dates.
Select the measure field.
Click OK.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.