background color expression stacked bar chart

[ilanbaruch]

Hi all

in my model i have a stacked bar chart with Company Name and quarter as a dimensions , 

showing largest 6 (dimension limit)

trying to set default color (in expression background color) for every company with below expression :

if(CompanyName='CompanyA',RGB(85,142,213),
if(CompanyName='CompanyB',RGB(229,182,148),
if(CompanyName='CompanyC',RGB(195,214,155),
if(CompanyName='CompanyD',RGB(27,125,156),
if(CompanyName='CompanyE',RGB(77,167,65),
if(CompanyName='CompanyF',RGB(128,120,64),
))))))

still colors are not persistent

any ideas ?

advanced thanks

[Claudiu_Anghelescu]

try to put this on Dimension background color, not Expression background color