Forum Discussion
Solved
PowerBI Matrix - Unable to do some conditional formats on values
I am trying to do conditional formatting on a matrix. Its not just based on a value (like high or low), it's comparing values from the same table column [formatted value]. And not all rows have...
I would create a Rules table for that
and then apply those rules in the font color conditional formatting
Thank you for your reply. Below is a table on how I need the data to be represented in the matrix. Like I said above, there are different rules based on the measure. Just a note on the 'formatted value' = that is a measure that just formats the value in either percentage or decmimal, based on the measure.
| Measure | TimeValue | Organization Program (field = formatted value) | State Program (field = formatted value) |
| ACP | Q3 2024 | 32% | 52% |
| Avg Days CPC | Q3 2024 | 154.4 | 134.6 |
| CPC | Q3 2024 | 45% | 65% |
| Screening | Q3 2024 | 33% | 49% |
| Disenrollment | Q4 2024 | 13% | 8% |
| Enrollment | Q4 2024 | 14% | 12% |
| Positive Screen | Q3 2024 | 52% | 78% |
I would create a Rules table for that
and then apply those rules in the font color conditional formatting