Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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
@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