cancel
Showing results for
Did you mean:
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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: undefined

Hi @jcastr02 ,

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

14 REPLIES 14
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

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.

Best Regards,
Icey

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

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

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.

Member

## Re: undefined

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

## Re: undefined

Hi @jcastr02 ,

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

Best Regards
Icey

Member

Member

## Re: undefined

@Icey    see if above works?

Member

## Re: undefined

if not I can attach more screen shots

Announcements

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

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

Find out where you can attend!

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