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:

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

savulesc you cannot use conditional formatting on a column used in the rows but if you are using table visual, you can apply conditional formatting on the column on a row. Add a new measure for conditional formatting and then use table visual and apply field value for Name column using the color measure

 

Color KPI = 
VAR __actual = [Actual Measure]
RETURN
SWITCH ( TRUE(),
   __actual > .80, "Green",
   __actual < .75, "Red"
)

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 

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

I didn't really understand your response, but I don't want to use conditional formatting on the Name column , because that doesn't help me at all.