How to Create Date Range Slicer in Power BI?

In this Power BI slicer tutorial, I will show you how to create a date range slicer in Power BI so that you can create filters for a date column in the data model.

Here, you’ll learn:

• Adding Date Range Slicers to a Power BI Report
• Power BI Create Relative Date Range Slicer
• Filter the Relative Date Range Slicer in Power BI
• How to Create a Relative Time Slicer in Power BI

Add a Date Range Slicer in Power BI

The Power BI date slicer can be used to filter the data in your data model based on a specific day, month, or year. By default, the date slicer is similar to a numerical range slicer, where you can apply filters to any numeric data.

The Power BI date slicer filters data based on a hierarchy of information, including Year, Quarter, Month, and Day.

Follow the steps below to create a Date Range Slicer using Power BI:

1. Launch the Power BI Desktop app -> click on the ‘Get data’ button from the ribbon menu. Select the data source from the list of options. Here, I have connected to an Excel data source.

2. Then, you’ll see the window below. Select the checkbox of the Sheet. Click the Load button to load the data into the Power BI report view.

The data source is now connected, and the Excel columns will be displayed under the Data pane.

3. Now, navigate to the Visualizations pane. Under the Build visual section, click on the Slicer icon.
4. Next, drag and drop the ‘Start Date‘ column to the Field option of the slicer.

Output:

The date range slicer will now be added to the report view in Power BI.

Check out Slicers in Power BI Report

Display Power BI Slicer Between Two Date Columns

By default, the slicer displays the date range with the ‘between’ option, showing the minimum and maximum date values.

When you add a Date field to a slicer, it displays a horizontal range bar with the minimum and maximum date range limits, allowing users to drag the left and right circles to set the date range between two dates.

Additionally, you can enter the minimum and maximum dates directly in the text fields.

Let me show this with an example.

Here, I have a Power BI report with a ‘Table‘ visual that displays project details, including Project ID, Project Name, Start Date, and End Date.

Now, I want to filter the table values between two dates.

You can drag the bar to set the date range between two dates. It will filter the table data like this:

The table chart shows the data filtered by the data range slicer.

This is how to work with a date range slicer in a Power BI report.

Check out Add and Customize a Dropdown Slicer in Power BI

Filter Data on Before and After Date in Date Range Slicer in Power BI

Here, I will demonstrate how to filter data on a Power BI report based on specific dates before and after using the slicer.

The Power BI report displays the Table visual with ‘Project details’ as shown in the image below.

Here, I wanted to filter the table data based on the Start Date value before a specific date.

To change the date range in the Power BI slicer settings, update the date range options. Check the steps below:

1. On the Power BI report view, select the slicer.
2. Go to the Visualizations pane and click on the ‘Format your visual‘ icon.
3. Expand Slicer settings.
4. Under the Options section, change the style from “Between” to “Before”.

5. When you update the slicer date range settings to ‘Before‘, the Minimum date value will be greyed out, as shown in the image below. You will only select the date before the maximum date.

Then, drag the date range bar to the maximum date range [20-01-2025].

Output:

Similarly, selecting the After option in the date range slicer disables the option to choose maximum date values and allows you to select any date after the minimum date value.

Suppose you want to filter the projects in the table after a specific date. Drag the bar range to the right of the particular date [15-01-2025].

Output:

Read Add and Customize Button Slicer in Power BI

Create a Relative Date Range Slicer on Power BI Desktop

With a relative date slicer, we can apply a time-based filter to any date column in our data model in Power BI.

This allows users to filter the data dynamically on the Power BI report based on the relative time periods. For example,(last 10 days, Next 7 Months, This 1 Year )

Look at the steps below to set up the relative date range slicer:

1. On to your Power BI report view, add a Slicer visual and select the date value in the Field section.
2. Then, select Slicer. Navigate to the Visualizations pane.
3. Expand Slicer settings -> Select Options.
4. Change the style to “Relative Date“.

When you select “Relative Date” in the Slicer settings, the slicer will be displayed with three sections, as shown in the image above.

• For the first setting in the relative date range slicer, the following options are available: Last, Next, or This.

• You can enter a number in the second or middle setting of the relative date slicer to define the relative date range.

• On the third setting of the relative date range slicer, a drop-down with date measurement is provided with values such as [Days, Weeks, Weeks (Calendar), Months, Months (Calendar), Years, Years (Calendar)].

Let me explain this with an example.

Check out Add Search Box to Power BI Slicer

Filter the Last 2 Months of Data using Relative Date Slicer in Power BI

Suppose, let’s assume that you have a table visual that shows ‘Project Details‘ from 2024 -2025.

Now, you want to filter the data to show the projects that have started in the last 5 months.

We can easily filter this by using the Relative Date Slicer visual in Power BI.

1. On the Power BI Relative Date Slicer, select the following settings.
   • First – Last
   • Second – 5
   • Third – Months

The above slicer retrieves the last 5 months’ projects based on the Project start date from the current date. Today’s date is 25-07-2025.

Result:

If you choose the third setting as ‘Months (Calendar)’, then the data will be filtered based on the current month. It will filter the last five complete calendar months (01-02-025 to 30-06-2025). Today’s date is 25-07-2025.

Result:

This is a simple way to filter your Power BI report by the last month, last week, the next five months, and so on.

Check out Sync Slicers in Power BI

Use Filters in the Relative Date Range Slicer in Power BI

We can also create a relative date range filter for our report page or total report. This option is also available for the Filter pane.

To implement this, drag a date field into the page-level filters well or the report-level filters well in the Filter pane.

After selecting the Relative date option, it will display the same features, with three sections to change, including a middle numeric field, similar to the slicer.

We can add or remove today by checking or unchecking the Include today option.

Relative date filtering in the Power BI report is easy to use, allowing us to navigate within the selected period range.

Read Remove Blank From Slicer in Power BI

Create a Relative Time Slicer in Power BI

By using the relative time slicer or relative time filter, you can implement time-based filters on any date or time column within your data model.

Example: You can use the relative time slicer to show the video views within the last minute or an hour.

When you apply a relative time filter or slicer at the page or report level, all visuals on that page or report are filtered to the same time range by using a shared anchor time.

Follow the steps to create a relative time slicer:

1. On to the Power BI report view, select the Slicer visualization type.
2. Drag and drop a date or time field to the canvas.

3. Select the slicer, and in the Format pane, under Visual > Slicer settings > Options, change the Style to Relative Time.

Then the relative time will be added to the slicer. Here’s what it looks like in a slicer.

This is how to create a date range slicer along with time in Power BI.

From this Power BI Tutorial, we learned all about the Power BI Date range slicer. Do mention your suggestions about this article in the comments section.

You may like the following tutorials:

• Get selected value from Slicer in Power BI
• Create a Measure based on Slicer in Power BI
• Power bi slicer contains with examples
• Power bi slicer checkbox

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.