Forum Discussion
How to apply conditional formatting to matrix rows based on a calculation group?
Hi, I have a matrix in my report which looks like this:
| KPI_1 | KPI_2 | KPI_3 | |
| Value_current | 100 | 75 | 200 |
| Value_last_week | 80 | 100 | 200 |
| Growth_vs_last_week | 25% | -25% | 0% |
The column headers (KPI_1, KPI_2, and KPI_3) are all measures, which are placed in the 'values' section of the matrix.
The rows (Value_current, Value_last_week, and Growth_vs_last_week) are all calculation items within a calculation group. This calculation group is placed in the 'rows' section of the matrix. The calculation group has been created through Power BI itself, not Tabular Editor.
I want to add conditional formatting to the Growth_vs_last_week row only, to show whether growth is positive, negative, or neutral. The result should look like this:
| KPI_1 | KPI_2 | KPI_3 | |
| Value_current | 100 | 75 | 200 |
| Value_last_week | 80 | 100 | 200 |
| Growth_vs_last_week | 25% | -25% | 0% |
Does anyone know how to do this please?
2 Replies
Hi SRJPBI
The conditional formatting feature of Power BI Matrix Visual allows you to change colors based on differences in measures or values, but does not allow individual color customization of entire rows.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
