Forum Discussion
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] is between Measure 1 and Measure 2, Yellow
If [Completion_Rate] is greater than Measure 2, Green
Is this possible?
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
2 Replies
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
amitchandak Worked like a charm. Thanks. 😃
