Forum Discussion
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
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
4 Replies
Hi Anonymous
Requirement is not clear, please describe and please share sample screenshot.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 🙂
Anonymous
Please use Conditional Formatting logic for all column
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formattingIf Solved, mark as 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
