Date filter update after data source refreshing

[mithiladas02]

I am wondering is there any way to automatically update date filters when refreshing your data source.

As of right now, I  filtered for year, month,  but when refreshing my data source, the filters are stuck on the date that I had saved the dashboard. It is showing previous month untill user change the most recent month data refreshed.

Need to fix always populate the most recent month for which data available.

Thanks in advance.

[amitchandak]

@mithiladas02 , You need to create a column like below and use that in slicer and and save this month or last month

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA