Bar Chart with Time Slicer - Colors Issue

Hi,

I have a Clustered Bar Chart with the following settings:

Axis:

Method

Name

Legend:

Fiscal Year

Value:

Amount

And I designated a color for each Fiscal Year legend.

It shows the values and color correctly, but then I added a Time Slicer to my report, the one that come from the regular Slicer, which was recently upgraded.

When in the slicer I pick the dates of ranges that fall only in the second fiscal year, I get the correct values in the chart, but I still get the two colors mixed in the bars, it actually shows more bars with the "last year color" even though the value is this year's. The tooltip shows fine, the value, the "in detail records", everything except the color.

If I pick the first year dates, the color shows correctly, but if I pick the second year dates, the colors get mixed.

With values from 2 fiscal yearsWith values only from 2nd fiscal year

I will greatly appreciate any hints to solve this.

Thank you in advance!

Have a great day!

Brenda