Previous year 6 months and current year month data.

[dkbr]

Hi Experts !

Need your help. Indian financial year starts from Apr and end on March. From April_2023 new financial year has started. So what i want, when i will select financial year 2023-2024 & Month April in a Slicer then it should display
the data for previous year's 6 months i.e. October 2022-23 to current year's Month i.e. April_2023.There will be total 7 months data. Same should be apply for all the next months also,
means when i will select May then data should be display data from November 2022-23 to May 2023-24. In short it should apply all the next months also. This Slicer should filter all the visuals on my power bi desktop.
Please provide the solution. Hope you understand the problem. If i missed something pls let me know.

Thanks!!

[amitchandak]

@dkbr ,when you select one date and want to show data more than that. You need to have a slicer on an independent date table 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -6) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[dkbr]

Hi @amitchandak, sorry for delay reply. I saw your video & that's great. But it will work for that specific visual only. I need a slicer for N months (same as which is in your video) and it should filter all the visuals on a page ( there are total 13 visuals on my page). Can you pls provide furthermore solution? Thanks!