cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcastr02 Member
Member

undefined

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

 


TAT.png

1 ACCEPTED SOLUTION

Accepted Solutions
Icey Super Contributor
Super Contributor

Re: undefined

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.

View solution in original post

14 REPLIES 14
JosefPrakljacic Established Member
Established Member

Re: undefined

Hey @jcastr02,

 

here you will find everything what you need for your request.

 

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

Icey Super Contributor
Super Contributor

Re: undefined

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.

condition2.PNG

condition.PNG condition3.PNG

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jcastr02 Member
Member

Re: undefined

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**TAT2.png

 

 

Icey Super Contributor
Super Contributor

Re: undefined

Hi @jcastr02 ,

Which version of your Power BI Desktop is it? Maybe you need to update it.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jcastr02 Member
Member

Re: undefined

@Icey hello, I've downloaded the latest version, but the colors are still showing off.  

Untitled1111.png
Here is my DAX: 

Conditional Formatting - TAT =
if (max ( 'Process Improvement Change Request'[Priority]) = "Minor",
if ( Max ( 'Process Improvement Change Request'[TAT Hours])> 170, 1, 0),
if ( max ('Process Improvement Change Request'[Priority]) = "Major",
If(max('Process Improvement Change Request'[TAT Hours]) > 72, 1, 0),
if( max( 'Process Improvement Change Request'[Priority]) = "Critical",
If (max('Process Improvement Change Request'[TAT Hours]) > 24, 1, 0))))
Icey Super Contributor
Super Contributor

Re: undefined

Hi @jcastr02 ,

That is so strange. If you don't mind, please share your PBIX with me.

 

Best Regards
Icey

jcastr02 Member
Member

Re: undefined

@Icey    see if above works?

jcastr02 Member
Member

Re: undefined

if not I can attach more screen shots

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,920)