topic Re: Make Date in the Slicer temporary and have the ability change it outside the parameters in DAX Commands and Tips

Make Date in the Slicer temporary and have the ability change it outside the parameters

Thenewguy — Thu, 21 Jan 2021 20:19:06 GMT

I am using the Between format for the Date slicer. What i need is to set the end date of the date range to Today's date and the remainder of the month. So when everytime i open the dashboard ,it should show - Todays (1/20/2020) and the remainder of the month (1/1/2020). I also want to also want the ability to filter outside these dates.

Re: Make Date in the Slicer temporary and have the ability change it outside the parameters

amitchandak — Fri, 22 Jan 2021 05:52:04 GMT

Thenewguy , You can not initialize the date columns

But you can have column like this in your date table and use it as filter

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0) && [Date] <=Today() ,"This Month Till Date" ,
eomonth([Date],0)= eomonth(Today(),0) && [Date] >Today() ,"Rest of the Month" ,
Format([Date],"MMM-YYYY")
)

refer

https://www.youtube.com/watch?v=hfn05preQYA

Re: Make Date in the Slicer temporary and have the ability change it outside the parameters

Thenewguy — Fri, 29 Jan 2021 20:33:00 GMT

This works but if the date slicer is filtered on prior months, the "This Month Till Date" option disappears. I need that option to be seen at all times. Thank you for you help