Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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).
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).
Should that be _days in the switch statement instead of _due_date?
@kleigh wrote:Should that be _days in the switch statement instead of _due_date?
That was it, fixed now 🙂
This is giving me everything as a Green status
16th August should be Red?
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |