Based on filter month selection to update chart data

[#1]

Hi Team,

We have a Storyboard filter for is Month.

Data Source: File Server(excel file)

Please help on the below scenario,

Scenario: If select month selections as below to show in the chart,

Jan: Dec 2021, 2022: Jan Actual, 2022: Mar, June, Sep & Dec Budgets (all are quarters last month)

Feb: Dec 2021, 2022: Feb Actual, 2022: Mar, June, Sep & Dec Budgets

Mar :Dec 2021, 2022: Mar Actual, 2022: June, Sep & Dec Budgets

Apr :Dec 2021, 2022: Mar, Apr Actual, 2022: June, Sep & Dec Budgets

May :Dec 2021, 2022: Mar, May Actual, 2022: June, Sep & Dec Budgets

Jun :Dec 2021, 2022: Mar, Jun Actual, 2022: Sep & Dec Budgets

Jul :Dec 2021, 2022: Mar, Jun, Jul Actual, 2022: Sep & Dec Budgets

Aug :Dec 2021, 2022: Mar, Jun, Aug Actual, 2022: Sep & Dec Budgets

Sep :Dec 2021, 2022: Mar, Jun, Sep Actual, 2022: Dec Budgets

Oct :Dec 2021, 2022: Mar, Jun, Sep, Oct Actual, 2022: Dec Budgets

Oct :Dec 2021, 2022: Mar, Jun, Sep, Nov Actual, 2022: Dec Budgets

Dec :Dec 2021, 2022: Mar, Jun, Sep, Dec Actual

If the Month is Aug 2022 then the chart show as like below,

Thanks,

chandrasekhar