Forum Discussion
Waterfall Chart - Start and End Date
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 selec...
amitchandak
Super User
Super Userdataconsole , 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) )