This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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
QBeeQ - Gold Implementation & Development Partner
