Forum Discussion
Conditional formatting for one hierarchy level
I have a matrix where I want conditional formatting to apply only to one level of the hierarchy, the "name" level. The rows "Anthony Heaven" and "Cassie Mesko" should have a background color, but...
Hello, Have you found a solution to this?
Yes, I did. If it's helpful to you:
Conditional formatting: Background Color
Format style: Field value
Apply to: Values and Totals
What field should we base this on: conditionalformatting
Formula for that field:
conditonalformatting =
VAR varLevel2 = ( 90 / 100 )
VAR varLevel1 = ( 35 / 1000 )
RETURN
SWITCH (
TRUE(),
ISINSCOPE ('Projector Deployment Report Current and Planned'[Stage]), BLANK (),
ISINSCOPE ('Resource Assigned Practice Group'[Name]) &&
([Utilization Rate]) >= varLevel2, "#efb5b9",
ISINSCOPE ('Resource Assigned Practice Group'[Name]) &&
( ([Utilization Rate]) >= 0.7 && ([Utilization Rate]) < 0.9), "#f0e199",
ISINSCOPE ('Resource Assigned Practice Group'[Name]) &&
([Utilization Rate]) < 0.7, "#d0ef9e",
"#ffffff"
)