Hello,
I am trying to apply different conditions on a Matrix to highlight the cells:
1)
value < Threshold1 --> Green
Threshold1 <= value < Threshold2 --> Yellow
value >= Threshold2 --> Red
As you can see from the photo I was able to do it, using conditional formatting by field value and by creating the measure Background_color:
Background_color =
IF(Min(FinalTable[Threshold1])=-1,"white"
,IF(Min('FinalTable'[value]) < MIN('FinalTable'[Threshold1]),"#1af329"
,IF(Min('FinalTable'[value]) >= MIN('FinalTable'[Threshold2 ]),"#ff0c0c"
,"#FFFF00")
)
The point where I'm struggling is:
When the Threshold is -1 (shown as blank value in the matrix), I would need the rows' background color to be formatted with a gradient:
GREEN for the smallest value in the row, RED for the highest value in the row, and a gradient for the values in between.
Is there a way to do it?
Thank you very much
