Forum Discussion

mithiladas02's avatar
mithiladas02
Helper I
4 years ago

Date filter update after data source refreshing

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.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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