Dear Community,

I want to change the colors of my grouped bar chart by expression. If I use the following function it is working for single bar charts (showing only the values of 1 week) but not for grouped ones (showing the values for 4 weeeks = 1 month).: 

if(colourcodestatus='OK', Green(),if(colourcodestatus='NOK', Red(), RGB(255,204,0)))

I have 5 different measures in my bar chart each of them shows how many NOK/OK parts I have (as percentage)
The parts can be made in 5 different stations. --> 5 measures
My x-axis is a timeline showing the month of the current year.

Following are the conditions: 
If there are 80 - 100% OK parts the color of the bar should be green. 
If there are less then 80% OK the color should be red as well as when there are more then 100% OK parts. 
PLUS if there is 1 NOK part in a month I want to see a yellow bar even if the percentage is actually 'OK'. 

Thanks in advance! 

Kind regards,
Rebecca