How to apply conditional formatting to matrix rows based on a calculation group?

[SRJPBI]

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?

[zenisekd]

FYI: https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-by-row-in-matrix/m-p/250775

[Anonymous]

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.