The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 nothing above or below this hierarchy level. This level of the hierarchy is called "Resource".
The conditional formatting should run on a different measure called "Utilization Rate". If Utilization Rate is greater than 0.90 (90%), the cell should become red. If it is 70%-90%, yellow. If it is 70% or less, green.
Looking through other posts, it looks like the best course of action is to create a measure and then use that as the basis for conditional formatting, but I cannot get it to work.
I created this measure:
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:
Hi @kault ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Color =
SWITCH(
TRUE(),
ISINSCOPE('Table'[Group3]) && [Utilization Rate] >0.9 ,"red",
AND(ISINSCOPE('Table'[Group3]) ,[Utilization Rate] >0.7) && AND(ISINSCOPE('Table'[Group3]) ,[Utilization Rate] <=0.9),"yellow",
ISINSCOPE('Table'[Group3]) && [Utilization Rate] <=0.7 ,"green")
2. Conditional formatting – Background color.
3. Enter Background color.
Format style – Field value
What field should we base this on – [Color]
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
81 | |
57 | |
48 | |
48 |