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...
Hi Anonymous, hello Poojara_D12 and bhanu_gautam, thank you for your prompt reply!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
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?