Forum Discussion
Conditional Formatting in Power BI Matrix Based on Dynamic KRI Status Thresholds
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?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.