How to Add Date Picker in Power BI

Trying to give your users a way to filter your Power BI reports by a specific date range? Adding an interactive date picker is the perfect solution. This guide will walk you through exactly how to implement a flexible and user-friendly date slicer, from setting up a proper date table to customizing its final look and feel.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First Things First: Why You Need a Dedicated Date Table

Before you just drag a date field onto your report, it’s important to understand a core Power BI best practice: the date calendar table. While you could technically use a date column directly from your sales or marketing data (a "fact table"), it can cause inaccurate calculations and limit your report's flexibility.

A dedicated date table is a separate table that contains a continuous, unbroken list of dates, along with helpful columns like year, quarter, month, and day of the week. Think of it as the ultimate calendar reference for your entire data model.

Why bother with this extra setup?

• Accurate Time Intelligence: Power BI’s time intelligence functions (like YTD, QTD, SAMEPERIODLASTYEAR()) require a continuous date range to work correctly. If your sales table has no sales on a particular day, that date is missing. A calendar table ensures every single day is present, making your calculations reliable.
• Slicing Across Multiple Data Tables: Imagine you have sales data, marketing data, and inventory data, all with their own date columns. A single, central calendar table can be linked to all of them. This allows one date slicer to filter every visual on your report simultaneously, creating a truly connected dashboard.
• Enhanced Filtering Options: With a date table, you can create reports that filter by "Fiscal Quarter," "Day of the Week," or any other custom time period you want to add, giving you much more analytical power.

How to Create a Calendar Table in Power BI

Creating a calendar table is easier than it sounds. You have two main methods: using a simple DAX formula or building one in Power Query. We’ll cover both.

Method 1: Creating a Calendar Table with DAX (Recommended)

Using Data Analysis Expressions (DAX) is the fastest and most common way to create a dynamic calendar table directly within Power BI.

1. Navigate to the Data view on the left-hand side of Power BI Desktop.
2. Go to the Home tab in the ribbon and click New Table.
3. A formula bar will appear. Enter the following DAX formula. This function will automatically scan your data model for the earliest and latest dates it can find and create a table that spans that entire period.

Calendar = CALENDARAUTO()

Hit Enter. You'll now see a new table named "Calendar" with a single column called "Date."

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Adding More Columns To Your Date Table

A single date column isn't very useful on its own. Let's add columns for Year, Month, Month Name, and Quarter to make it truly powerful.

With your new 'Calendar' table selected in the Data View, click New Column from the "Table tools" tab for each of the following formulas:

• Year:

Year = YEAR([Date])

• Month Number:

Month = MONTH([Date])

• Month Name:

MonthName = FORMAT([Date], "MMMM")

• Quarter:

Quarter = "Q" & FORMAT([Date], "Q")

After adding these columns, your final step is to tell Power BI that this is your official date table. Go to the "Table tools" tab, click Mark as Date Table, select the ‘Date’ column as the unique date column, and click OK. This formally designates it for your time intelligence functions.

Method 2: Creating a Date Table with Power Query

If you prefer a more visual, step-by-step approach without writing formulas, Power Query is a great alternative.

1. In Power BI Desktop, click Transform data from the Home tab to open the Power Query Editor.
2. In the Power Query window, go to the Home tab, click New Source, and select Blank Query.
3. In the formula bar, type = #date(2020, 1, 1) (or whatever start date you prefer) and hit Enter. This creates a single date value.
4. Rename this query to something descriptive like "Calendar". Now, right-click on the date value itself and select Drill Down. This turns the query's output into a single date value instead of a table.
5. Now, let's create a list of dates. We'll need a start and end date. Go back to New Source > Blank Query to create two more queries:
6. Now, we'll create the list. Create another Blank Query again. In the formula bar for this new query, type:

= { Number.From(StartDate) .. Number.From(EndDate) }

This creates a list of numbers representing every day between your start and end dates. To turn these numbers back into dates:

1. With the list generated, click To Table in the ribbon, and then click OK.
2. Right-click the column header and change its Type to Date.
3. From here, with the date column selected, you can use the Add Column tab to easily add Year, Month, and Quarter columns by simply clicking the options in the "Date" menu.
4. Once you’re finished, click Close & Apply on the Home tab.

Regardless of the method you choose, remember the final, critical step: Go to the Model view, find your new calendar table, and drag its 'Date' column onto the corresponding date column in your main data table (e.g., your Sales table's 'OrderDate' column). This creates the relationship that makes the slicer work across your whole report.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Adding the Date Slicer to Your Report

Now for the easy part! With your data model correctly set up, adding the actual date picker is just a few clicks.

1. Return to the Report view in Power BI.
2. In the Visualizations pane on the right-hand side, click off any existing charts or graphs, then click the Slicer icon. A blank slicer visual will appear on your reporting canvas.
3. From the Data pane, find your newly created calendar table.
4. Drag the main Date field from your calendar table into the "Field" well of the new slicer visual.

That's it! Power BI automatically turns this into a select date range slider. Clicking on and moving the sliders will dynamically filter everything on your report that has a relationship with the date table.

Customizing Your Date Slicer

The default slider looks fine, but Power BI offers you plenty of possibilities to tailor it to your report's precise needs.

Select the slicer and navigate to the Format tab (the paintbrush icon) in the Visualizations pane. There you'll find various categories with options to adjust:

1. Slicer Style

Under Slicer Settings > Style, you can choose from different input options. The default is Between, which provides a range slider. Other helpful options include:

• Dropdown: Compresses the date chooser into a single dropdown menu, saving valuable screen real estate. Users can select individual dates from a list.
• List: Displays all available dates in a long, scrollable list. This is most useful with a very small number of specific dates.
• Relative Date: This is powerful. It lets users choose dynamic ranges like "Last 7 days," "Next 7 months," or "This year." The range automatically updates based on "today's" date without any manual input required from the user.
• Before: Provides a single date picker to show all data on or before a specific date.
• After: Provides a single date picker to show all data on or after a specific date.

2. Text and Numeric Inputs

Under the Slicer settings panel, you'll see options to adjust the font color, size, and background of the text within the slicer itself. This can help match the slider to the overall theme of your report. Under this section, you can also customize or even hide the text label of the slicer for a cleaner appearance.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

3. General Aesthetics

The General tab offers more opportunities to adjust the look and feel. Here, you can change items like the slider's outline color, selection color (the bar between the two end dates), or add a background color to make the slicer stand out from the rest of your report's background.

Tuning these settings lets you transform the slicer visual into a polished, intuitive tool that makes your report feel more like a full-fledged application.

Final Thoughts

Adding a date slicer in Power BI is a straightforward way to make your reports interactive and far more useful for day-to-day users. By setting up a dedicated calendar table and customizing the slicer visually, you can empower everyone to explore data within the time frames that matter most to them.

We know that even straightforward tasks within Power BI, like setting up date tables and relationships, can feel like death by a thousand clicks. We engineered Graphed to eliminate all that hassle. Instead of manually setting up your data model, connecting tables, and formatting visuals, you can ask in plain English, "Show my web traffic from the UK for the last 30 days." Then it connects all your marketing sources in one place and generates the dashboard you need instantly, giving you back time to act upon that data instead of merely structuring it.