cancel
Showing results for 
Search instead for 
Did you mean: 

Conditionally format a measure based on another measure

Ido_QBeeQ
9 - Travel Pro
9 - Travel Pro

Sometimes we would like to color code a measure (A) not by its performance rather by another measure's (B) performance. The problem is that when applying the conditional formatting on measure A, the measure A is static in the equation.

To work around this, one will need to take measure B function into consideration into the conditional formatting calculation of the measure A, and move it to the other side of the equation. You need to color A according to B, if A is above or 2000:

What you need - A>2000

What you have is B static on the left hand side of the equation, so you need to multiply by B and divide by A :

B>(B/A)*2000 => B/B>(B/A)*2000/B => 1>2000/A => A>2000

See screenshot and attached dash file

Always here to help 🙂

Ido 

[email protected]

QBeeQ - Gold Implementation & Development Partner

111.png

 

0 REPLIES 0