Forum Discussion
Background Colour based on date
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?
Anonymous
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 _resultThen use this measure in conditional formatting. (Format style by Field value).
4 Replies
Anonymous
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 _resultThen use this measure in conditional formatting. (Format style by Field value).
