Forum Discussion
Date slicer
Hi, I have a date slicer from dim_date table which is connected to the fact_tables. Now, I want the date filter to show todays date, even if there is no data available
Use a measure to set today’s date as the default filter in the slicer.
DefaultDate =
IF(
MAX('dim_date'[Date]) = TODAY(),
1,
0
)
Add the DefaultDate measure.
Set the filter to show only rows where DefaultDate = 1.
This ensures the slicer highlights today’s date by default but still allows the user to select other dates if needed.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn