Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have a matrix that measures the completion rate of POs by weekday, what I need to do is to set a conditional formatting by row category, meaning that each PO Category should contain different parameters of color coding, for example, for PO Cancel, if %>=75, green; else if %>=50, yellow, else if %<50, red.
Another tricky part is that I have independent columns for each weekday due to the way the data is structured, so each column by day is independent from one another.
Is there a way to apply conditional formatting by Row Category?
I believe you should be able to change your measure and use DAX to specify the colours. See if this thread helps: https://community.powerbi.com/t5/Desktop/Customized-Conditional-Formatting-Using-DAX/m-p/733277
Yes, thank you! I actually ended up doing something very similar to that:
But I think this was possible because I had the days sepparately and I could reference them individually, not quite sure, but thanks!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |