I make a example for my question. On the sheet I have 4 bar charts, de top charts are simple and bottom chart are with alternative dimension.
With colour by expression option I know how to modify each color, but when I combine the two dimension in one chart I don't get a good solution. The bar marked with yellow circle should be green.
I'd want one funciton that can give me the dimension or condition necesary to choose one Pick or another .
The expresion would be similar to:
Pick(Match(Class,'A1', 'A2','B1'), rgb(139,109,188), rgb(255,128,192), rgb(163,163,163) ),
Pick(Match(Group,'Group A', 'Group B'), rgb(171,55,52), rgb(153,181,96) )