How to Create a Timeline in Power BI

Building an interactive report means giving users the power to explore data on their terms, and one of the most effective ways to do that is with a timeline filter. This guide will walk you through how to create and customize a timeline in Power BI, allowing you and your team to slice your data by date ranges with ease. We’ll cover using the standard slicer visual, a powerful custom visual dedicated to timelines, and how to create timeline charts that tell a story.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Why Do You Need a Timeline?

In Power BI, a timeline isn’t just a visual aid, it’s an interactive filtering tool. It allows users to select specific periods - days, weeks, months, quarters, or years - to narrow down the data shown in other visuals on the report. Instead of static reports showing "last month's data," a timeline empowers users to ask their own questions:

• How did sales perform during our Black Friday campaign?
• What was our website traffic like in Q2 compared to Q1?
• Is this week's marketing performance better or worse than the same week last year?

An interactive timeline answers these questions instantly, turning a one-dimensional report into a dynamic analytical tool.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Begin: The Importance of a Date Table

Before you add any visuals, it's essential to have a proper date table in your data model. While you can often use a date column directly from your sales or traffic tables, this can cause problems. A dedicated date table is a best practice that makes time-based calculations and filtering much more reliable.

A date table is a separate table containing a continuous list of dates, typically with additional columns for year, quarter, month, week, and day of the week. Connecting this table to your main data tables (like a Sales table) on the date field lets Power BI’s time-intelligence features work correctly.

You can create one quickly using a simple DAX formula. Go to the “Data” view, select the “Table tools” tab, and click “New table.” Then enter this DAX formula:

Calendar = CALENDAR ( MIN ( 'YourDataTable'[DateColumn] ), MAX ( 'YourDataTable'[DateColumn] ) )

Remember to replace 'YourDataTable'[DateColumn] with the earliest and latest dates from your own data. After creating it, make sure to connect it to your other tables in the “Model” view.

Method 1: Using the Default Slicer Visual

The simplest way to create a timeline filter is with Power BI’s built-in Slicer visual. This is your go-to option for standard date range filtering.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions:

1. Add the Slicer Visual: In the “Report” view, find the “Visualizations” pane on the right-hand side. Click the Slicer icon (it looks like a funnel with a slice through it) to add it to your report canvas.
2. Add Your Date Field: With the slicer selected, drag the main date field from your Calendar table (e.g., Calendar[Date]) into the “Field” well in the Visualizations pane. Power BI will automatically create a date range slicer.
3. Format the Slicer: By default, you’ll get a slider with a start and end date. This is useful, but you have many different options. Select the slicer, then click the small down-arrow in its top-right corner to see different modes:

For most timeline use cases, the Between option is what you’ll want. To customize its look, select the slicer, go to the “Format visual” tab (the paintbrush icon), and explore options under “Slicer settings” → "Options" and “Slider.” You can adjust the colors and fonts to match your report’s design.

Method 2: The Timeline Slicer Custom Visual

If you want a more intuitive and visually appealing timeline, the ‘Timeline Slicer’ custom visual from Power BI’s AppSource is an excellent choice. This visual displays dates in a clear, clickable format divided by years, quarters, months, and weeks.

Users find it much easier to quickly jump between fiscal periods with this visual compared to the sometimes-finicky default slider.

Step-by-Step Instructions:

1. Import the Custom Visual: In the “Visualizations” pane, click the three dots (...) at the bottom and select "Get more visuals." This opens AppSource. Search for “Timeline Slicer” and click “Add.”
2. Add It to Your Report: A new icon for the Timeline Slicer will appear in your Visualizations pane. Click it to add the visual to your canvas.
3. Drag in Your Date Field: Just like with the default slicer, drag your primary date field from the Calendar table into the “Time” field well for this visual.
4. Configure and Use: The timeline will immediately appear. Your users can click a year (e.g., 2023), which then reveals the quarters within that year, then the months, and so on. They can click and drag to select a range or hold Ctrl to select multiple non-adjacent periods.

This visual is a fan favorite because it makes navigating through a company’s history feel natural. You can customize colors, text sizes, and even show a "fiscal year" instead of a calendar year in its formatting options.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Creating a Visual Timeline with a Chart

Sometimes when people say "timeline," they don't mean a filter - they mean a chart that shows data over time. A line chart is the perfect way to visualize key metrics chronologically.

Step-by-Step Instructions:

1. Choose a Line or Area Chart: In the “Visualizations” pane, select either the "Line chart" or "Area chart" icon and add it to your report. Area charts are great for visualizing volume over time, while line charts are better for tracking trends.
2. Configure the Axes:
3. Utilize the Hierarchy: Power BI automatically creates a date hierarchy (Year, Quarter, Month, Day). You’ll see drill-down buttons at the top right of the chart. This allows you to start at a high-level view (e.g., yearly sales) and drill down into quarters, months, and individual days to investigate trends.
4. Add Trend Lines and Forecasts: To add more analytical depth, select your line chart and go to the "Analytics" pane (the magnifying glass icon) in the Visualizations pane. From here, you can add a "Trend line" to see the overall direction of your data or a "Forecast" line to project future performance based on historical data.

Best Practices for Effective Timelines

• Sync Your Slicers: By default, a timeline slicer will filter every visual on the page. You can customize this by going to the "Format" tab and selecting "Edit interactions." Then, you can choose which charts should or shouldn't be affected by your timeline.
• Place it Prominently: Date filters are usually the first thing users interact with. Place your timeline slicer at the top or on the left side of your report where it’s impossible to miss.
• Less is More: Avoid cluttering your report with too many different date filters (e.g., a year slicer, a month slicer, AND a date range slider). A single, well-configured timeline slicer is often all you need.

Final Thoughts

Whether you use the standard slicer, a custom visual, or a classic line chart, creating a timeline in Power BI is about giving your data context. By allowing users to freely explore different time periods, you move from static reporting to real, interactive analysis.

We know that even with great tools like Power BI, connecting data from scattershot sources and building meaningful reports can be a manual, time-consuming ordeal. At Graphed, we automate that whole process. We connect to your marketing and sales tools in seconds and let you build real-time dashboards by simply describing what you want to see - "show me Shopify revenue vs. Facebook Ads spend for this year." Our goal is to handle the reporting drudgery so you can spend your time finding insights, not wrestling with data.