Forum Discussion
Default value for filters
I have a report with a date filter in it. Is it possible to give default values to them (preferably pogrammatically) such that every time the report loads, the report is shown for the default values,...
Relative Date Slicer → set it to Last 2 weeks → every time the report loads, it defaults to that window.
DAX Measure + Filter → create a calculated column like:
IsLast2Weeks = IF([Date] >= TODAY()-14, 1, 0)
Then filter the page/visuals where IsLast2Weeks = 1.
For published reports, you can also use Bookmarks → save a default state (like “last 2 weeks”) and set it as the entry view.
Best practice: use the Relative Date Slicer, it’s built for exactly this use case.