Cumulative running total & view last 2 years from a single slicer selection

[Marcus2]

I would like to select my cumulative running total end date from a single slicer selection and view prior 2 years of data for comparison purposes.

Excel data:

Date	FY	Value
10/31/2022	2023	97
11/30/2022	2023	48
12/31/2022	2023	56
1/31/2023	2023	27
2/28/2023	2023	36
3/31/2023	2023	77
4/30/2023	2023	1
5/31/2023	2023	21
6/30/2023	2023	61
7/31/2023	2023	82
8/31/2023	2023	61
9/30/2023	2023	86
10/31/2023	2024	97
11/30/2023	2024	17
12/31/2023	2024	96
1/31/2024	2024	47
2/29/2024	2024	70
3/31/2024	2024	98
4/30/2024	2024	80
5/31/2024	2024	87
6/30/2024	2024	38
7/31/2024	2024	8
8/31/2024	2024	57
9/30/2024	2024	41
10/31/2024	2025	46
11/30/2024	2025	40
12/31/2024	2025	94
1/31/2025	2025	55
2/28/2025	2025	83
3/31/2025	2025	16
4/30/2025	2025	74
5/31/2025	2025	35
6/30/2025	2025	33
7/31/2025	2025	22
8/31/2025	2025	97
9/30/2025	2025	50

My bar chart funtions fine from a single slicer selection:

The DAX for my line chart does not terminate the cumulative running total at my slicer selection.  If I turn on the month slicer I get 3 dots on the visual... If I turn off the month slicer I get full years of data (as shown below):

Current Dax for Running Line Chart =

var _SelectedMonth = Max(DateTable[FYMonthNumber])

var _SelectedYear = Max('DateTable'[FiscalYear])

var _StartOfFiscalYear = Date(_SelectedYear-3,10,1)

var _EndOfFiscalYear = Date(_SelectedYear,9,30)

var _FilterDates = Filter(All('DateTable'),'DateTable'[Date] >= _StartOfFiscalYear && 'DateTable'[Date] <= _EndOfFiscalYear && 'DateTable'[FYMonthNumber] <= _SelectedMonth)

Return

Calculate(Sum(ExcelSheet[Value]), _FilterDates)

Here is my desired result (created with paint editor).  Any DAX to achieve this?

[Marcus2 · Accepted solution]

Thanks, I found what I needed.  It took me a while... I'm new to DAX

[BeaBF]

@Marcus2 Hi! Try to disactive the relationship between calendar tables and Excel Table.

Can you share the pbix?

BBF

[Marcus2]

Only pro-level users can attach files.  When I disconnect my calendars the MonthName slicer stops controlling my bar chart... and the line chart is still doesn't funtion.

[BeaBF]

@Marcus2 it does not matter, it's a different stuff. Try to disactivate relationship.

BBF