Conditional Formatting Matrix or Table Help

[Anonymous]

Hello,

Just a quick help here.

So I have this table.

And on my Report I summarize it by product and qty.

The one i got stuck is, i want to highlight the product that is the Highest Hour.

In this example the highest hour is Hour 5, and on hour 5, product E and F needs to be highlighted.

Let me know if this is possible.

[mahoneypat · Accepted solution]

You need to generate a column to hold the hour value in integer format, so that you can compare the max hour for each product to the overall max in your color measure.

For example 

Color Measure = IF(MAX(Table[Hour]) = CALCULATE(MAX(Table[Hour]), ALL(Table[Product])), "Yellow", "White")

Regards,

Pat

[Icey · Accepted solution]

Hi @Anonymous ,

Please check:

Measure 1 =
IF (
    MAX ( 'Table'[Hour] )
        = CALCULATE ( MAX ( 'Table'[Hour] ), ALLSELECTED ( 'Table'[Product] ) ),
    "Yellow"
)

Measure 2 =
IF (
    MAX ( 'Table'[Hour] )
        = CALCULATE ( MAX ( 'Table'[Hour] ), ALLSELECTED ( 'Table'[Product] ) ),
    1
)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[mahoneypat · Accepted solution]

You need to generate a column to hold the hour value in integer format, so that you can compare the max hour for each product to the overall max in your color measure.

For example 

Color Measure = IF(MAX(Table[Hour]) = CALCULATE(MAX(Table[Hour]), ALL(Table[Product])), "Yellow", "White")

Regards,

Pat