Need help on Pie chart color

[praveensprabhu]

Hi,

I have an issue with Pie chart color based on a condition. 

I have a Pie chart that should not be affected by any filter condition. so I have used set analysis. but when I select any filter value, the pie chart shows entire data but the colors are highlighted only for the selected filter value, rest of the slices in pie chart are shown in white color and the legends color change to black.

please see below screenshots - 

Chart Properties - 

I have used the BG color on Expressions. This is the expression I am using - 

=if(Statuss = 'Closed',green(),if(Statuss = 'Inactive/Archived',LightGray(),if(Statuss = 'On-Going',Yellow())))

Let me know where I am doing wrong. I tried by keeping this expression in BG color property of dimension. It isn't working there either. 

Thanks,

Praveen Prabhu

[Kushal_Chawda · Accepted solution]

@praveensprabhu  try below expression in BG color

=if(only({1}Statuss) = 'Closed',green(),if(only({1}Statuss) = 'Inactive/Archived',LightGray(),if(only({1}Statuss) = 'On-Going',Yellow())))

[praveensprabhu]

Thank you....This expression worked.