KPI Conditional Formatting

---

Anonymous wrote:

HI All,

 

I am using a KPI to color green, red, orange from two fields which use dynamically changing data ie. the value changes. But when the value change the KPI displays the wrong color.

 

Desired Logic;

IF (B-A)>0, THEN [Green]

IF(B-A) <0, THEN [Red]

IF(B-A)=0, THEN [Orange]

 

You can see in screen shot that B is larger than A but it is red.

Second screen shot shows the fields used for A.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

These columns are in different data sets. So we are unable to do a merge join or condiitonal formatting on the data, so I need a custom DAX for this? 

 

Thanks for any assistance.

---

Anonymous

I’m not getting the "A" and "B" in your screenshots, could you be more specific? The color coding for the KPI works fine in my test. Also, when considering "A" equals "B", the would show green instead of oranage as you expect. Check KPI neutral color.