I have taken over a dashboard that has a matrix with around 18 Columns/values. Most of these have their own conditional formatting however the method is similar for all of them. For example >= 0 but less than 50 is red, >=50 and <70 is yellow and then above that point is green. They are thinking of testing out different colors for those ranges and rather than having to change each one of them I was wondering if there could be a generic measure that has the ranges and the color values which is then used in the conditional formatting. I know I could set up a measure and choose the specific field I want to use but I was curious if there was a 'generic' way to set this up so that I could use the same measure for all the different values. Is that possible or do you have to create a separate measure for each value/field?
