Dinamic Colour in Line Chart

[#1]

Hello Guys,

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.

Ex:

CompanyName,Colour

AAA,RGB(0,0,0)

BBB,RGB(230,74,14)

etc....

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.

Thanking You

regards

Anup

[marcus_malinow]

Hi Anup,

Try changing the Expression Background Colour to '=Only(Colour)'

Marcus

[#3]

Thanks Marcus fir your reply. But it's not working.

[#4]

Hi,

You can use nested if's in the expression background color to change it according to your dimension.

Amay

[Anonymous]

go to Expression -->expand your expression--> select background color--> give RGB() value according to your preferred color. same steps you can use for next expression also.

Thanks,