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, 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!
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 |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |