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).
