Forum Discussion
Solved
Conditional Formatting Based on Other Measures
I would like to apply Conditional Formatting to a matrix column, [Completion_Rate], based on the values of 2 other measures. If [Completion_Rate] is less than Measure 1, Red If [Completion_Rate]...
TD21
Create a color measure likeColor Measure =switch(True(), [Completion_Rate] < [Measure 1], "Red",
[Completion_Rate] >= [Measure 1] && [Completion_Rate] <=[Measure 2], "Yellow",
[Completion_Rate] >=[Measure 2], "Green",
"black"
)Use it under conditional formatting with "field" option
TD21
Create a color measure like
Color Measure =switch(True(), [Completion_Rate] < [Measure 1], "Red",
[Completion_Rate] >= [Measure 1] && [Completion_Rate] <=[Measure 2], "Yellow",
[Completion_Rate] >=[Measure 2], "Green",
"black"
)
Use it under conditional formatting with "field" option
amitchandak Worked like a charm. Thanks. 😃
