Formating the date column

Anonymous — Fri, 08 Dec 2023 10:47:12 GMT

Hello,

I would like to color the date column as below :

IF date < 2 months : RED

2 - 4 months : Orange

> 4 months : green

Name	Value	Date
Name 1	Value 1	09/10/2023
Name 2	Value 2	20/09/2023
Name 3	Value 3	20/09/2023
Name 4	Value 4	20/09/2023
Name 5	Value 5	10/03/2023
Name 6	Value 6	11/03/2023
Name 7	Value 7	12/03/2023

Result :

Could you please advise ?

Thank you in advance.

Re: Formating the date column

devesh_gupta — Fri, 08 Dec 2023 11:05:24 GMT

Anonymous You can use rule based conditional formatting to color the date column. You can refer this video to know how to implement rule based conditional formatting.

https://youtu.be/Fq0JneLDbGs?si=hTyyxWF-407Acrbp

If you find this insightful, please provide a Kudo and accept this as a solution.

topic Re: Formating the date column in DAX Commands and Tips

Formating the date column

Re: Formating the date column