Date Colour Coding Conditional Formatting

[HenryJS]

Hi all,

I would like to create a conditional formatting to the below 'Available' date column.

The conditions would be:

• Green for 2 weeks in future
• Amber for 2 weeks in past
• Red for >2 weeks in the past

Thanks,

Henry

[az38 · Accepted solution]

Hi @HenryJS 

create a calcualted column

Column = SWITCH(TRUE(),
DATEDIFF(TODAY(), [Available], WEEK) > -1 && DATEDIFF(TODAY(), [Available], WEEK) <=2, "Green",
DATEDIFF(TODAY(), [Available], WEEK) < 0 && DATEDIFF(TODAY(), [Available], WEEK) >= -2, "Amber",
DATEDIFF(TODAY(), [Available], WEEK) < -2, "Red",
BLANK()
)

then set this column as a field for conditional formatting in the visual settings

do not hesitate to give a kudo to useful posts and mark solutions as solution

[chelynne]

My powerbi didn't even recognize switch. This looked so promising but did not work for me