Highlight Maximum Test Time Based on Specific Criteria in Table.

[Anonymous]

Hi Power Bi Expertise,

Need your helps on how to highlight in table for maximum test time based on specific criteria? Mean 

[v-luwang-msft · Accepted solution]

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]

Hi @Anonymous 

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

[Anonymous]

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 🙂

[PijushRoy]

@Anonymous 
Please use Conditional Formatting logic for all column
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

If Solved, mark as SOLUTION