Forum Discussion
Conditional Formatting in Power BI Matrix Based on Dynamic KRI Status Thresholds
Hi everyone, I'm working on a Power BI report and need some help with conditional formatting in a matrix visual. I have two tables: KRI and KRI results, connected by a one-to-many relationship betwe...
KRI Results:
| ID | KRI ID | Result | Department | Quarter |
| 1 | 70 | 8 | Marketing | 1 |
| 2 | 70 | 4 | Sales | 1 |
| 3 | 70 | 19 | IT | 1 |
| 4 | 71 | 5 | Marketing | 1 |
| 5 | 71 | 8 | Sales | 1 |
| 6 | 71 | 3 | IT | 1 |
| 7 | 70 | 6 | Marketing | 2 |
| 8 | 70 | 7 | Sales | 2 |
| 9 | 70 | 7.5 | IT | 2 |
| 10 | 71 | 4 | Marketing | 2 |
| 11 | 71 | 5.5 | Sales | 2 |
| 12 | 71 | 7 | IT | 2 |
KRI Info:
| ID | KRI ID | KRI Name | Red | Orange | Yellow | Green |
| 1 | 70 | % retained | <6 or >20 | 6-8 or 18-20 | 8-10 or 16-18 | 10-16 |
| 2 | 71 | % absent | >= 7 | 6-7 | 4.5-6 | <4.5 |
In my matrix I use KRI results table. In the rows I have KRI ID, in the columns I have department and in the Values I have result. Is it possible to implement conditional formatting here?
Hi Anonymous , thank you for your sample data.
Based on my tests and research, there doesn't appear to be an out-of-the-box solution for this requirement.
The challenge lies in the need to dynamically obtain and apply different formatting rules for various colors within a single measure. Each color has its own unique formatting rule, which adds to the complexity.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.