Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Conditional formatting based on 1 column field and calculated measure
i m trying to implement a conditional formatting, to change the background color of a matrix cell.
My code is
Condition_first_reply_time_50 = SWITCH(TRUE(); FactTickets[requesttyp]="question" && [First Reply Time (hrs)50%] >= 8; "Red"; FactTickets[requesttyp]="change" && [First Reply Time (hrs)50%] >= 8; "Red"; FactTickets[requesttyp]="service" && [First Reply Time (hrs)50%] >= 8; "Red"; FactTickets[requesttyp]="incident" && [First Reply Time (hrs)50%] >= 4 ; "Red"; "#83BC00")
Hi @mofai ,
I tested with above formula, it set conditional colors as expected.
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |