Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm having a bit of trouble with something and I was hoping you could help me out. I'm trying to add a conditional format to the background of my matrix table, but it's giving me some errors. The error message is super unhelpful and it's not telling me what's wrong or how to fix it. I've been trying to add it as a column, but for some reason, it's not working at the table level. So, I thought maybe I could give adding a measure a shot. Any suggestions on how to tackle this?
Method
Error
Code
Color_Idlev =
SWITCH(
TRUE(),
VALUES(Data[Support Title]) = "Technical Support Engineer"
&& AVERAGE(Data[Idle (Hrs)]) >= 45,
"#6082B6",
VALUES(Data[Support Title]) = "Advanced Technical Support Engineer"
&& AVERAGE(Data[Idle (Hrs)]) >= 45,
"#6082B6",
VALUES(Data[Support Title]) = "Senior Technical Support Engineer"
&& AVERAGE(Data[Idle (Hrs)]) >= 75,
"#6082B6",
""
)
Links
Files
https://drive.google.com/file/d/1rlnDUc3cYCgsuUyXYzfzA52YnKZpHIbH/view?usp=sharing
Data
https://drive.google.com/file/d/1KC6chRm9q4aBH2FqDCvKto6_4PpJmCeu/view?usp=sharing
Thank you so much
Solved! Go to Solution.
Hi @Zack92
In your SWITCH try using SELECTEDVALUE insead of VALUES
Phil
Proud to be a Super User!
Hi @Zack92
In your SWITCH try using SELECTEDVALUE insead of VALUES
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |