I've got a matrix in place at the minute using sub-totals for 10 pieces of data. One value is 13, the other is 11 but this can vary based on user input via filters I have in place.
Is there a way of achieving this using Conditional Formatting? When I go into the options to do this and choose to look attotals only, I have to put in a custom minimum value and maximum value which isn't what I need.
Visual expectation below:
I've been looking through aMicrosoft documentonline which has a limitation of:
Conditional formatting applies only to the values of Table or Matrix visuals, and doesn't apply to any subtotals, grand totals, or theTotalrow.
This makes me assume I'm unable to achieve this using Conditional Formatting, is there a way of doing this using a measure perhaps?
I can add the conditional formatting, the problem is that when I go into the options to do this and choose to look attotals only, I have to put in a custom minimum value and maximum value which isn't what I need.
It needs to be able to look at the values being shown and determine of those, which is the highest and highlight it as such.