Showing results forย 
Search instead forย 
Did you mean:ย 

Conditionally format a measure based on another measure

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 ๐Ÿ™‚


[email protected]

QBeeQ - Gold Implementation & Development Partner