Conditional formatting just for some cells in a matrix

I have a matrix with this structure: NAME Program Actual Kpi1 R1 66.5 Kpi1 R2 43.5 Kpi1 R3 70.9 Kpi2 R1 2 Kpi3 R2 2 Kpi4 R3 3 Name and Program are colum...

Need Help

jdbuchanan71

3 years ago

Add a measure to set the formatting color and check for the KPI1 row like this.

Format Color = 
SWITCH ( 
    TRUE(),
    SELECTEDVALUE ( YourTable[Name] ) = "KPI1",
    SWITCH(
        TRUE,
        [Actual] <= 75, "Red",
        [Actual] >= 80, "Green"
    )
)

Then apply that measure as the background color to the value:

Forum Discussion

Conditional formatting just for some cells in a matrix

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting with Matrix Table

Conditional Formatting

Conditional Formatting