How to Add Date Filter in Power BI Dashboard

Viewing your data over a specific period is fundamental to good analysis, and adding a date filter to your Power BI dashboard is the perfect way to do it. This filter allows you and your team to easily slice your data to view performance for last week, the past quarter, or a specific marketing campaign window. This guide will walk you through the most common methods for creating and customizing date filters, from simple drag-and-drop options to more advanced, interactive slicers.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Date Filters are Essential for Your Dashboard

Before jumping into the "how," let's quickly cover the "why." A well-implemented date filter transforms a static report into an interactive analytical tool. It empowers users to:

• Analyze Trends Over Time: Quickly switch between weekly, monthly, and quarterly views to spot patterns, seasonality, or performance dips.
• Compare Performance Periods: Easily compare this month's sales to last month's, or analyze year-over-year growth without needing to build separate visuals.
• Isolate Specific Timeframes: Focus exclusively on the results of a two-week product launch or a weekend promotional event.
• Improve User Experience: Instead of creating dozens of charts for different time periods, you can create one dynamic dashboard that your team can filter themselves, saving everyone time.

Method 1: Using the Filters Pane for Back-End Filtering

The simplest way to filter by date is by using Power BI's built-in Filters pane. This method is great for setting a default date range on a report page or a specific chart that you don't necessarily want users to change interactively. The Filters pane is usually located on the right side of your Power BI canvas.

Three Levels of Filtering

The Filters pane lets you apply filters at different levels:

1. Filter on this visual: The date filter will only apply to the single chart or visual you have selected.
2. Filter on this page: The date filter will apply to all visuals on the current dashboard page.
3. Filter on all pages: The date filter will apply globally across every page in your report.

For most dashboards, filtering on a page or a specific visual are the most common uses.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Set a Basic Date Filter

Let's say you want an entire page to only show data for the last 90 days.

1. Make sure you don’t have any specific visuals selected on your canvas.
2. Find your date column in the Data pane (e.g., OrderDate).
3. Drag the OrderDate field into the Filters on this page bucket in the Filters pane.
4. A filter card will appear. Under "Filter type," select Relative date.
5. In the "Show items when the value" dropdowns, select is in the last, enter 90, and select days.
6. Click "Apply filter."

That's it! All visuals on the page are now automatically filtered to show only data from the previous 90 days. You can also explore other filter types in this pane, such as Basic filtering (checking off specific dates) or Advanced filtering (setting rules like "is after" or "is not").

Method 2: Adding an Interactive Date Slicer for Users

While the Filters pane is useful, the real magic for user interaction comes from adding a slicer. A slicer is a visual element that lives directly on your dashboard canvas, allowing anyone viewing the report to easily change the date range themselves.

Step 1: Add a Slicer Visual to Your Report

From the Visualizations pane, click the Slicer icon. It looks like a small funnel with a filter. This will add a blank slicer template to your dashboard canvas. You can click and drag it to position it wherever you like - typically in a sidebar or across the top of the dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Add Your Date Field to the Slicer

With the new, empty slicer selected, go to your Data pane and find your date column (e.g., SalesDate). Drag this date field into the "Field" well for the slicer visual. Power BI will automatically recognize it as a date and create a ranged slider.

Step 3: Choose Your Slicer Style

By default, Power BI creates a "Between" range slider. While this is useful, it's not the only option. To change it, select your slicer and then, in the Visualizations pane, click the Format your visual icon (the paintbrush).

Navigate to Slicer settings > Options > Style. You'll find several choices:

• Between: The default slider with a start and end date.
• Before: A slider that lets users set a maximum date.
• After: A slider that lets users set a minimum date.
• List: A huge list of every single date that users can check. (Use with caution, as this can be very long and overwhelming.)
• Dropdown: Puts the list of dates into a space-saving dropdown menu.
• Relative Date: This is a very powerful option that provides dynamic choices like "Last 3 months" or "Next 2 weeks." This is often more intuitive for business users than picking specific dates.

Step 4: Format Your Slicer for Clarity

An unformatted slicer is functional but can look messy. Take a moment to clean it up.

1. Select the slicer and go to the Format your visual tab.
2. Slicer header: Toggle the title on or off and change its text (e.g., change OrderDate to "Select a Date Range"). You can also adjust the font and background color here.
3. Slicer settings: Depending on the style, you can adjust formatting. For sliders, this is where you can turn on the "Relative Date" option mentioned above.
4. Values: Change the font color, size, and background of the date text itself.
5. General: Under "Properties" you can adjust the size and position, and under "Effects" you can add a border or shadow to help it stand out on the page.

Now you have a fully functional and polished date slicer that anyone viewing the report can use to explore the data.

Pro Tip: Use a Dedicated Date Table

Once you get comfortable with Power BI, you'll find that using a dedicated Date Table (also called a Calendar Table) is a universal best practice. Instead of relying on the date columns in your sales or marketing data, you create a separate table that contains a complete, unbroken series of dates.

Why it's Worth a Few Extra Clicks:

• Time Intelligence Functions: It is required for sophisticated DAX time intelligence functions like DATESYTD (dates year-to-date) or SAMEPERIODLASTYEAR.
• Consistency: It ensures every visual in your report is using the same source of truth for dates.
• Flexibility: You can easily add extra columns to your date table for things like "Day of Week," "Month Name," or "Fiscal Quarter" to allow for even more filtering options.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Creating a Simple Date Table Using DAX

You can create a basic date table in seconds using a DAX formula.

1. In the menu, go to the Modeling tab and click on New Table.
2. In the formula bar that appears, enter the following DAX formula and press Enter:

Dates = CALENDARAUTO()

1. This CALENDARAUTO() function will automatically scan your whole data model, find the earliest and latest dates, and generate a new table named "Dates" with a [Date] column that contains every single day between those points.
2. Finally, go to the Model view (the icon on the far left that looks like connected tables). Find your new Dates table and create a relationship by dragging its [Date] column to the date column in your primary data table (e.g., Sales[OrderDate]).

Now, when you build date filters or slicers, use the [Date] column from your new Dates table instead of the date columns from your other tables. This makes your report more robust, scalable, and powerful.

Final Thoughts

Adding a date filter in Power BI, whether through the Filters pane or an interactive slicer, is a foundational skill that immediately makes your reports more dynamic and useful for your audience. Mastering these options will allow you to build dashboards that don't just present data, but also encourage exploration and lead to much faster insights.

Of course, this setup process highlights the manual work and learning curve often involved in traditional BI tools. At Graphed, we created a tool to eliminate that friction. Instead of having to build filters, format slicers, and create relationships, you can simply connect your data and ask in plain English, "show me my revenue by source for the last quarter." We believe getting to the insight should take seconds, not hours of setup, and built our AI data analyst to handle all the heavy lifting for you.