Conditional color on KPI chart does not fully work

[prae01]

I want the KPI chart to fully reflect such that for instance, 2014 Net Sales are displayed. Under conditional coloring, if Net sales 2014 > Net sales 2013, it turns red, else it turns green.

While it is red (which is supposedly correct), I tested with multiplying the value into 2, which should already be green, but it still appears red. It is red until I multiply into 2.95, and after that number it is green. It is wrong as the value 2014>2013 already before it is multiplied into 2 (refer to table screenshot) .I tried moving around the scaling, changing expressions from greater to and lesser than (> and <) , to getting the difference which got me the closest, but still not accurate.

I would appreciate a foolproof way to get a fully accurate result. Attaching screenshots for context and a table for context on why it is wrong. 

Thanks a lot for the help

[henrikalmen]

Could you please show the conditional coloring settings as well?

[JandreKillianRIC]

Hi @prae01 

I must mention that I also struggled a bit with this one... 

Firstly I would make the Set Analysis more dynamic. 

First Measure 

Sum({<Year = {"$(=Max(Year))"}>} Sales)

with Label expression 

='Sales '&Max(Year)

Second Measure 

Sum({<Year = {"$(=Max(Year)-1)"}>} Sales)

with Label Expression 

='Sales '&Max(Year)-1

For the colors 

The expression would just be 

=Sum({<Year = {"$(=Max(Year)-1)"}>} Sales)

This would work and by nice and dynamic 

Regards Jandre