Hello,
I would like to have a fixed range corresponding to a color gradient so that, for instance, if the number hits 40% or above, it will show the same color and not change the range depending on how the data is filtered. However, if I set the auto color rule to a fixed range like that, it blanks out everything over 40% instead of treating them all as the same color.
I’ve had to set it as 0 to 100% instead, but this makes my color range really small (hard to distinguish colors) on larger date ranges (for instance looking at month-to-date, they’ll have large percentages at first that get smaller as they have more data for the full month)
ETA: Just in case a visual helps make sense of what I mean about “blanks out everything over 40%”
