Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have the following table. I need to highlight the dates red if it is in the past and the status open. If status is closed, or date is in the future. It stays black. Please help.
Due date | Status |
2023/09/04 | Closed |
2023/08/01 | Open |
2023/09/08 | Open |
2024/01/04 | Open |
Solved! Go to Solution.
Hello @akhassim ,
First create the following measure
Date color =
Var selected = SELECTEDVALUE('Table'[Start date])
return
IF( selected> TODAY() && SELECTEDVALUE('Table'[Status]) = "Open", " Red" )
Then go to the date field and select conditional formatting and select font color
then select format style as field value and date color measure
and this is the result
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Hello @akhassim ,
First create the following measure
Date color =
Var selected = SELECTEDVALUE('Table'[Start date])
return
IF( selected> TODAY() && SELECTEDVALUE('Table'[Status]) = "Open", " Red" )
Then go to the date field and select conditional formatting and select font color
then select format style as field value and date color measure
and this is the result
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |