The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
241 | |
124 | |
121 | |
81 | |
79 |