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.
Hi Everyone,
I'd like to ask for your help. I have data with different targets per SLA. Minimum column is also target but it's the minimum % an SLA must have.
I created a measure that I will use to create an icon (using conditional format) to determine if the SLA Summary results met the target or not.
Here's a screenshot of my conditional format for the icons in case you need.
Solved! Go to Solution.
Hi @Newbie22 Try it
_ConditionSLATarget =
SWITCH(
TRUE(),
[_SLA Summary Results] >= [Target],1,
[_SLA Summary Results] >= [_Minimum],0,
[_SLA Summary Results] < [_Minimum],-1)
Hi @Newbie22 Try it
_ConditionSLATarget =
SWITCH(
TRUE(),
[_SLA Summary Results] >= [Target],1,
[_SLA Summary Results] >= [_Minimum],0,
[_SLA Summary Results] < [_Minimum],-1)
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |