Forum Discussion
KPI Conditional Formatting
Hi Anonymous,
I don't understand the 'ChannelClean' value in the Trend Axis. It only makes sence to add some sort of time to this.
There is something different in the filters of your KPI visuals compared to your card visuals - the KPI visual doesn't return a value of your AVG. (Goal).
Kind Regards,
Søren
Microsoft Employee
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.
Changing the KPI's to tables shows that the columns are returning nulls or zero and this ovbiously effects the KPI. Wether this is a bug with Power BI or the data not sure yet. Though its highly lightly to be the data with the issue.
You can see after a slicer selection that the fields are blank.