colour of pie chart selection determines the colour of the table

[bobbydave]

Is there a way that on selection of a slice of a pie chart, depending on the colour of the slice of the pie, that that colour will change the active caption of a table?

I'm assuming i need to capture the RGB of the slice and put it into the Active caption background colour as a calculated expression but if there are 6 different colour slices that have different RGB colours?

Help appreciated.

[avinashelite]

we don't have way how your excepting but try like this use the expression to set the slice color of the dimension values and then based on the dimension selection set the header color

Hope you got the answer

[krishnacbe]

Yes you are right, only you should use RGB colors in Pie Chart Expression and Other chart Active caption.

But one challenge will be if user selects multiple values in the Pie.

[bobbydave]

This is an example of what i am trying to achieve. You see the green portion will open a green active caption in the table and relevant data is associated with this green colour.

There wont be multiple selections as the table shows information relevant to the colour.

[krishnacbe · Accepted solution]

Your Expression Background color should be as below

if(Spend='Regulator', rgb(0,217,0))

your Chart Active Caption background Color should be as below

if(Spend = 'Regulator', rgb(0,217,0))

Add all your six combinations in else part

[bobbydave]

Yeah, i actually used simple 'if' statements in the end and it worked.

I think i may have been over complicating it.

But yeah, 'if' statements did it.