Help with Date Conditional Formatting (Due Date)

[swaggerboy69]

Hello!

I need help in using conditional formatting for dates.

I have a column for due dates and would want a color coded value when it's far from due date, almost due date and beyond due date.

For example.

I want Task Number and Due date background turned GREEN if it's far from it's due date.

ORANGE if it's close to its due date and

RED if it's beyond its due date.

[MFelix]

Hi @swaggerboy69 ,

What is the condition to have it Close/Far from due date?

If you create a measure similar to the one below you can have the desired result:

CondittionalFormatting =
VAR number_of_days =
    SELECTEDVALUE ( 'Table'[Due Date] ) - TODAY ()
RETURN
    SWITCH (
        TRUE ();
        number_of_days < 0; "Red";
        number_of_days < 10; "Orange";
        "Green"
    )

Just adjust the 10 days to whatever value you need then use it as your condittional formatting:

[swaggerboy69]

Hello! Thank you for your response.

Should I just add a measure?

Where do I get number_of_days?

I get red lines. Sorry I'm, not too good with codes.

[MFelix · Accepted solution]

Hi @swaggerboy69 ,

This is a measure and you should replace the ";" by ",".

CondittionalFormatting =
VAR number_of_days =
    SELECTEDVALUE ( 'Table'[Due Date] ) - TODAY ()
RETURN
    SWITCH (
        TRUE (),
        number_of_days < 0, "Red",
        number_of_days < 10, "Orange",
        "Green"
    )

The number_of_days is a variable is calculated on top as you can see tha make the difference between the due date and today.

[swaggerboy69]

Great. That worked. However how do I apply it to the table visual?

I only get the words.

[MFelix]

Hi @swaggerboy69 ,

You need to select the dates and task number and all the columns you need  then slected the condittional formatting and aplly the value of the measure see images below:

[swaggerboy69]

Thanks Miguel! It worked!