Forum Discussion

savulesc's avatar
savulesc
Icon for Helper I rankHelper I
3 years ago
Solved

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's avatar
    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:

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

If your [Actual] measure is a % then you would apply it at .75 and .8 like this.

Format Color = 
SWITCH ( 
    TRUE(),
    SELECTEDVALUE ( YourTable[Name] ) = "KPI1",
    SWITCH(
        TRUE,
        [Actual] <= .75, "Red",
        [Actual] >= .80, "Green"
    )
)
savulesc's avatar
savulesc
Icon for Helper I rankHelper I
3 years ago

I tried that already, it's still the same.