> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/add-date-filters.md).
# Add date filters
Date filters help users analyze data for specific dates or time periods. Use date-based filtering to make it easier to explore trends, compare periods, and focus on relevant data. Date filters provide multiple ways to filter report data by time - configure filters for specific dates, relative periods, or custom date ranges to create an interactive filtering experience.
### Configure a date slider
Add date sliders to your dashboards to focus on specific time periods.
1. Add a **Super Filter** visual.
2. Assign a date field to the **Category** bucket.
3. In the **Filter** ribbon, select **Date Slider** from **Quick Mode**.
4. Select **More options** (...) and ensure that **Date** is selected. It should not be **Date Hierarchy**.
4. In the **Filter** ribbon, select **Properties** to customize the slider.
5. Drag the handles to focus on a particular time period.
6. Select the calendar icon to choose a date range or select from built-in options such as *Last Calendar Month*, *Next Quarter*, MTD/YTD/QTD, *Last Fiscal Year*, and more.
### Configure a date picker
Use the calendar to filter dashboard data by selecting a specific date or date range.
1. Add a **Super Filter** visual.
2. Assign a date field to the **Category** bucket.
3. In the **Filter** ribbon, select **Date Picker** from **Quick Mode**.
4. Select **More options** (...) and ensure that **Date** is selected. It should not be **Date Hierarchy**.
5. Choose a calendar mode depending on the granularity of your data. Select **Properties** > **Calendar Customization** > **Calendar View.**
* Select **Multi Year** to filter data by specific years and selected months within each year.
* Select **Month Range** to select a period of time between a specific start and end date.
* Select **Week** to focus on specific weeks in a year.
* In the same way, use **Year**/**Month**/**Month Only** options.
### Configure a relative date filter
Use the relative date filter to apply filters based on the current date, such as past or next time periods.
1. Add a **Super Filter** visual.
2. Assign a date field to the **Category** bucket.
3. In the **Filter** ribbon, select **Relative Date** from **Quick Mode**.
4. Select **More options** (...) and ensure that **Date** is selected. It should not be **Date Hierarchy**.
5. In the date filter, select the settings icon to configure the time periods.
6. Set **Time Interval** to the required time period, such as year, quarter, month, or week.
7. Change the **Calendar Type** to **Fiscal** to filter based on fiscal time periods.
8. Adjust the time period to filter the next or past n time frames.
9. The dashboard data is filtered based on the selected time range.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/add-date-filters.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.