My colleague manage to do this. He added a column in the dataset of the dataSource with the name “Color” which each row has the value “green”, “orange” or “red”. (In our case the dataSource has a query binding so the logic that determines the color takes place in the query) Then he set the value of series/0/column/apperance/deriveFieldsFromData/fill/Color to Color. I think that is all that is required.