Colors greyed out after selection

[deniscamh]

Hi all,

I created a bar chart with the years and categories as dimensions:

My expression is: count({<Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])

When I make a Year selection the colors for not selected years become grey but the data still showing:

What should I do to prevent colors become grey?

Thank

[CarlosAMonroy]

Hi Denis,

Maybe just add the year to the set analysis as a exclude selection field. Something like:

count({<Year=, Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])

Hope that helps,

Carlos M

[deniscamh]

Thanks Carlos,

I already tried it.

Does not work, same result.

Thanks

[d44973694]

Did you find a solution to this?