I have a bar chart where I'm using custom colours to indicate if a value is above or below zero. Green if the value is above zero and red if the value is below.
This is my custom colour measure:
if(($(vTotal))>0.00, RGB(70,198,70),RGB(249,63,23)) //Green if not, Red
I'd like to change this so that I get a gradient between these two colours, similar to the built in Color By Measure function. I believe the Colormix1 function is what I need to apply to this, but I cannot get it to work. I've seen many posts about this, but nothing that I can relate directly to my issue, which I think is very straight forward?