Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Highlight Maximum Test Time Based on Specific Criteria in Table.

Hi Power Bi Expertise,   Need your helps on how to highlight in table for maximum test time based on specific criteria? Mean 
Show and Tell
Tutorial Requests
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    Hi Anonymous ï¼Œ

    Pls use measure like the below:

    test =
IF (
    MAX ( 'Table'[Test Time U] )
        = CALCULATE (
            MAX ( 'Table'[Test Time U] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[Machine] = MAX ( 'Table'[Machine] )
                    && 'Table'[Model Categroy] = MAX ( 'Table'[Model Categroy] )
            )
        ),
    "Red"
)

    Then format:

     

     

    Best Regards

    Lucien

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PijushRoy ,

 

Thanks for your fast response. BTW, here is the example of the table, i want to highlight row that have the max test time based on machine and model. Thanks 🙂