I have a line chart in which two dimenssions are there and one expression is there. Two dimenssion is Date & Company name. I show in this graph date wise sale for the company. So I get multiple line for the company.
In my data model I have a Colour coding table in which two fields are there one is Company Name & second one is RGB() value.
So in the sale expression background option I just put the field 'Colour' but the colour is not changed.
How can I maintain the colour for company through the different file.