Background Colour based on date

[Jason_Auburn]

Hi

I have a list of Due Dates in a column 'AP Report (2)'[Due Date]

I need to colour these based on the following=

If date has passed or due in the next 7 days = red

Date 2 weeks to 1 month = Orange

Date > 1 month = Green 

Would anyone be able to advise me how to acheive this?

[nandukrishnavs · Accepted solution]

@Jason_Auburn 

Create a measure

Color =
VAR _due_date =
    SELECTEDVALUE ( 'AP Report (2)'[Due Date] )
VAR _days =
    DATEDIFF ( TODAY (), _due_date, DAY )
VAR _result =
    SWITCH ( TRUE (), _days < 7, "Red", _days < 30, "Orange", "Green" )
RETURN
    _result

Then use this measure in conditional formatting. (Format style by Field value).

[kleigh]

Should that be _days in the switch statement instead of _due_date?

[Jason_Auburn]

---

@kleigh wrote:

Should that be _days in the switch statement instead of _due_date?

---

That was it, fixed now 🙂 

[Jason_Auburn]

This is giving me everything as a Green status

16th August should be Red?