Waterfall Chart - Start and End Date

[dataconsole]

Dear members,

I created a waterfall chart using : 

Year as Category

Product Category as Breakdown

Sales Amount as Value

To get a start year and end year as on pic below, i need to select two years on my slicer

As all other data are only meaningful when only one year is selected, would it be possible to achieve the same result with a formula and selecting only one year on the slicer, or a formula without the use of a slicer

Thank you ! Steve

[amitchandak]

@dataconsole , You need a very similar solution

Select data between months - https://youtu.be/nEt7dT3Tfv4

Using 2 slicer =
var _max = minx(allselected(Date1), Date1[Year])
var _min = maxx(allselected(Date2), Date2[Year])
return
calculate(countrows(Table), Filter(Table,Table[Year] <=_max && Table[Year] >=_min) )