Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have three different KPI's for each of the Priority levels. How can I set different conditional formatting for the results in a table. See screen shots below. This is how I would like it to show -
Minor - Show RED font if greater than 170, Green otherwise
Major - Show RED font if greater than 72, Green otherwise
Critical - Show RED font if 24 greater than 24, green otherwise
Solved! Go to Solution.
Hi @jcastr02 ,
Please change your condition measure like so:
Condition = IF ( MAX ( 'Table (3)'[Priority] ) = "Minor", IF ( AVERAGE ( 'Table (3)'[Value] ) > 170, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Major", IF ( AVERAGE ( 'Table (3)'[Value] ) > 72, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Critical", IF ( AVERAGE ( 'Table (3)'[Value] ) > 24, 1, 0 ) ) ) )
This is because of your "average" value in matrix.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jcastr02 ,
Is this problem sloved?
If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards
Icey
Hi @jcastr02 ,
You can create a measure like so:
Condition = IF ( MAX ( 'Table (3)'[Priority] ) = "Minor", IF ( MAX ( 'Table (3)'[Value] ) > 170, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Major", IF ( MAX ( 'Table (3)'[Value] ) > 72, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Critical", IF ( MAX ( 'Table (3)'[Value] ) > 24, 1, 0 ) ) ) )
And then, set conditional formatting.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello @Icey
I added the measure and the conditional formatting. One thing I notice is that I don't have the number field in the conditional formatting area. Any ideas? See screen shot below **I ended up using the font color vs. background color, assumming this is the same process anyways**
@Icey hello, I've downloaded the latest version, but the colors are still showing off.
Here is my DAX:
Hi @jcastr02 ,
That is so strange. If you don't mind, please share your PBIX with me.
Best Regards
Icey
if not I can attach more screen shots
Sorry it looks like it wont let me share, attached is screen shot where I show average of the turn around time, and the rules set , along with DAX. @Icey
Hi @jcastr02 ,
Please change your condition measure like so:
Condition = IF ( MAX ( 'Table (3)'[Priority] ) = "Minor", IF ( AVERAGE ( 'Table (3)'[Value] ) > 170, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Major", IF ( AVERAGE ( 'Table (3)'[Value] ) > 72, 1, 0 ), IF ( MAX ( 'Table (3)'[Priority] ) = "Critical", IF ( AVERAGE ( 'Table (3)'[Value] ) > 24, 1, 0 ) ) ) )
This is because of your "average" value in matrix.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |