Conditional Formatting Top and Lowest Value in Matrix Visual

Hi tayriley88 

Since columns/measures added in the "Value" field of the matrix are sperate, you need to format color for each column/measure.

For example,to  format for Opened Tickets,

First create measures for Opened Tickets,

opened_tickets = COUNT('opened by tickets'[tickets])

rank_open = RANKX(ALL(contacts[full_name]),[opened_tickets],,DESC,Dense)

colored_opened =
VAR top_open =
    MINX ( ALL ( contacts[full_name] ), [rank_open] )
VAR low_open =
    MAXX ( ALL ( contacts[full_name] ), [rank_open] )
RETURN
    SWITCH ( [rank_open], top_open, 1, low_open, 0 )

Next, add conditional formatting for the "opened_tickets" field,

See how to add "Conditional formatting in tables/matrix"

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.