Control Pie chart colors by selections

karin_nevo — Wed, 05 Apr 2017 05:57:59 GMT

Hi,

I have a pie chart with unknown number of segments.

when a specific value is selected, I would like the other segments to remain in chart, just grayed out.

To keep the other segments I ignored the dimension on the expression: ({<Dim=>} Count A), but I can't find a way to control the color.

the only thing I can think about is to define under the colors (or the backgroud in the expression):

If (getfieldsselections(Dim)='X',ColorA, ColorB) and define color B as gray.

But I don't want to use constant values on the field selections, becuase they can change.

Any other idea?

Thanks,

Karin

Re: Control Pie chart colors by selections

Anil_Babu_Samineni — Wed, 05 Apr 2017 06:06:08 GMT

this condition will work while you select Dim as X only.

If(GetFieldSelections(Dim)='X',Red(), LightGray())

for manually do this

If(Dim='X', Red(), LightGray())