Forum Discussion
AverageBiUser
3 years agoFrequent Visitor
Conditional Formatting on Matrix with % of Column Total
Above is how i would like to format my matrix, with a gradient colour scheme. However, not matter how hard i try to refine the filters in a conditonal formatting measure, I cannot get the desired output.
Below is always the result i get which shows conditional formatting based on total value, rather than column value.
Notice how Row 1, Column 4 has a value of 1 (below) but a value of 100% (above) - I would like this to be the darkest colour possible on the gradient of colours.
The row & column fields that support the matrix are from the same table as the measure