11 Replies Latest reply: Oct 22, 2014 5:58 AM by Alex Hamilton McLeod RSS

    Ensure colours do not change in bar chart

      I have an expression which defines the background colour for a bar chart I have

       

      if(wildmatch(Market, 'EMEA*'), RGB(141,170,203),if(wildmatch(Market, 'APAC*'), RGB(252,115,98),RGB(187,216,84)))

       

      It works well, until i start making selections in the Market field whereby the can bars change colour. Obviously I don't want that to happen, i want to colours defined above to stay fixed for each bar.

       

      How do i do this?