Forum Discussion
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.
Here is how the Rows and Values are added
Here is my relationship map. Contacts Table and Opened By Tickets are linked by opened by from Opened By Tickets and Full_name on the Contacts Table.
In a matrix visual how to achieve this ?
I have this measure,