Retain background colour

[#1]

I have a bar chart where the expression's background colour is set as follows;

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

However, when I make certain selections in my list boxes, the colours can change. How do I fix the colours of the bars on the bar chart so they cannot be changed no matter what selection is made?

[MK_QSL]

Check enclosed file...

[#3]

It's not actually the market field on my doc which impacts the colour. I have another field called 'Region' which impacts the colour

[MK_QSL]

Provide some sample dummy data !

[ThornOfCrowns]

Select the 'Persistant Colours' option in the Colours Tab.

[its_anandrjs]

Use Persistent color or you can use any inline table load for this also

Ex:-

Load * inline

[

Market,RED,GREEN,BLUE

EMEA,141,170,203

APAC, 252,115,98

Other,187,216,84

];

And then in the Background properties write

=RBG(RED,GREEN,BLUE)

[#7]

it is ticked

[Anonymous]

Hi,

Its just my thought. Your condition might be satisfying else part whenever you do selection in Region. For example, If you select Australia which is not linked to market "APAC" or "EMEA", you will get RGB(187,216,84) as a background color.

Thanks