Applying Conditional Formatting to a Matrix in Power BI | Highlight the MAX or MIN within the Row
In this Power BI tutorial, you'll learn how to highlight a specific value within a row of a matrix visual using conditional formatting. This step-by-step guide is perfect for both beginners and experienced users looking to enhance their Power BI visuals!
MEASURES
------------------------------------
1.) MarginCalc = AVERAGE(fact_table[margin])
2.) MaxInRow = VAR __MaxUnits =
MAXX(ALLSELECTED(dim_car[car_id],dim_car[car_make]),
[MarginCalc])
RETURN
IF([MarginCalc] = __MaxUnits,
"#B2CEE7")
LET'S CONNECT!
------------------------------------
LinkedIn: https://www.linkedin.com/in/sam-t-gross