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 mo...
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).
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
_result
Then use this measure in conditional formatting. (Format style by Field value).
