Alternate state is displaying values in the chart that are not part of the filter

[SindhuraK]

Hi,

I have 2 bar charts in same sheet and the requirement is to filter the data in these sheets separately using 2 different date filters.

When alternate state is not being used, filter is being applied correctly for the graph but when an alternate state is used, unnecessary data is being displayed.

For example, when month Apr is selected in the filter:

With Out Alternate State : Data of Apr month is being displayed.

With Alternate State: Data of Oct, Nov, Dec and Apr are being displayed.

Same is the case with any other month selected. Data for Oct, Nov and Dec are always being displayed.

Logic for the bar chart is as follows. This has been implemented this wat to consider financial year i.e Oct to Sep next year.

Count({$<Year_Cr={'23'},Month_Cr={'Oct.','Nov.','Dec.'}>+<Year_Cr={'24'},Month_Cr-={'Oct.','Nov.','Dec.'}>} distinct [ ID] )

I am unable to figure out a solution here where all FY details are visible in the chart when no filter is applied but specific month data is visible when that particular month is selected in the chart.