Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

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...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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's avatar
jcastr02
Post Prodigy
6 years ago

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's avatar
Icey
Community Support
6 years ago

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's avatar
    jcastr02
    Post Prodigy
    6 years ago

    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))))