Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this condition will work while you select Dim as X only.
If(GetFieldSelections(Dim)='X',Red(), LightGray())
Or
for manually do this
If(Dim='X', Red(), LightGray())