undefined

[jcastr02]

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

[Icey]

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

[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.

[jcastr02]

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]

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]

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

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]

Hi @jcastr02 ,

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

Best Regards
Icey

[jcastr02]

https://walgreens-my.sharepoint.com/:u:/p/joel_castro/EVvLq4xIF2tIp8NNIyrsTyQByt2cNiKMjkDx7_4FKvHVuw...

[jcastr02]

@Icey    see if above works?

[jcastr02]

if not I can attach more screen shots

[Icey]

Hi @jcastr02 ,

I have no access to your shared file.

Best Regards,

Icey

[jcastr02]

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 

[Icey · Accepted 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.

[jcastr02]

Thank you @Icey  this worked!

[JosefPrakljacic]

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