Forum Discussion
Advance conditional formatting with limits
I do not think you are able to "stack" conditional formatting. In your case you may be able to get around this by using a measure that feeds into the custom values in the gradient formatting.
As a small example, here is a list of numbers 1-20. I would like everything below my dynamic minimum value to be red, everything above my dynamic max value to be green and everything in between to be gradient.I could write a measure as follows that accepts my min and max measures and assigns any value in my list that is below(equal) to the min as 0 and anything that is above(equal) to the max as 1. The measure then calculates a percentage of max value for the remaining values that will give the selected value a value between 0 and 1. You can then set the custom values of the gradient as 0 and 1.
This is a bit of a wonky workaround, but it might work for you.
I do not think you are able to "stack" conditional formatting. In your case you may be able to get around this by using a measure that feeds into the custom values in the gradient formatting.
As a small example, here is a list of numbers 1-20. I would like everything below my dynamic minimum value to be red, everything above my dynamic max value to be green and everything in between to be gradient.
I could write a measure as follows that accepts my min and max measures and assigns any value in my list that is below(equal) to the min as 0 and anything that is above(equal) to the max as 1. The measure then calculates a percentage of max value for the remaining values that will give the selected value a value between 0 and 1. You can then set the custom values of the gradient as 0 and 1.
This is a bit of a wonky workaround, but it might work for you.