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

PijushRoy's avatar
PijushRoy
Community Champion
3 years ago

Hi Anonymous 

Requirement is not clear, please describe and please share sample screenshot.

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 🙂