Conditional Formatting Based on Other Measures

[TD21]

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?

[amitchandak · Accepted solution]

@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

Refer: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[TD21]

@amitchandak  Worked like a charm. Thanks. 😃