How to Show Quarterly Data in Power BI

Viewing daily or weekly results is great for spotting immediate trends, but to truly understand your business performance, you need a bigger picture. That's where quarterly reporting comes in. This article will walk you through several effective methods to show and analyze quarterly data in Power BI, from simple drag-and-drop techniques to more powerful DAX formulas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, The Essential Best Practice: A Date Table

Before you do any time-based analysis in Power BI, you need a proper date table. While you can sometimes get away with using the date column from your main data (like a sales or traffic table), it’s limiting and can lead to inaccurate results. A dedicated date table acts as the single source of truth for all things time-related in your report.

Creating one is straightforward. In Power BI Desktop:

1. Go to the Data view (the table icon on the left).
2. Select the Home tab in the ribbon and click New Table.
3. Enter one of the following DAX formulas:

For ultimate simplicity (let Power BI figure out the dates):

Date Table = CALENDARAUTO()

For more control (defining a start and end date):

Date Table = CALENDAR(DATE(2022, 1, 1), DATE(2024, 12, 31))

Once your table is created, you have two crucial final steps:

• With the new table selected, go to the Table tools tab and click Mark as date table. In the dialog box, select the [Date] column. This tells Power BI how to handle time intelligence functions correctly.
• Go to the Model view (the icon with connected boxes) and drag your new Date Table’s [Date] column onto the date column in your main data table (e.g., Sales[OrderDate]). This creates the relationship needed to filter your data.

With this foundation in place, you’re ready to add your quarterly data.

Adding Quarter Columns to Your Date Table

Now that you have a Date Table, you can add custom columns to it for your quarterly analysis. This is the cleanest way to manage your data, keeping all your date-related logic in one place.

While still in the Data View with your Date Table selected, you can add a new calculated column from the Table tools in the ribbon.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Simple Quarter Number

To get just the number of the quarter (1, 2, 3, or 4), use the QUARTER function.

Click New Column and enter:

Quarter Number = QUARTER('Date Table'[Date])

2. User-Friendly Quarter Name

A number is good, but for charts and reports, "Q1" or "Quarter 1" is more professional. You can easily create this by combining text with the previous function.

Click New Column and enter:

Quarter = "Q" & QUARTER('Date Table'[Date])

3. The Most Important Column: Quarter & Year

If you’re analyzing data across multiple years, "Q1" isn’t enough - you need to know if it’s "Q1 2023" or "Q1 2024". This column combines the quarter and the year and will be your primary field for visuals.

Click New Column and enter:

Quarter & Year = "Q" & QUARTER('Date Table'[Date]) & " " & YEAR('Date Table'[Date])

A Quick Tip on Sorting

A common frustration is that Power BI sorts text fields alphabetically. This means "Q1 2024" might appear before "Q4 2023" in your charts. To fix this, you need a "sort by" column.

Click New Column and create a numeric version of your quarter and year:

Quarter Sort = (YEAR('Date Table'[Date]) * 10) + QUARTER('Date Table'[Date])

Now, click on your Quarter & Year column, go to the Column tools tab in the ribbon, select Sort by column, and choose Quarter Sort. Your visuals will now display quarters in proper chronological order automatically.

Method 1: Using the Default Date Hierarchy (The Quick Way)

Power BI often creates an automatic date hierarchy for any recognized date field. This provides a fast way to get a quarterly view without needing a separate date table (though we still recommend it!).

Here’s how to use it:

1. Create a new visual, like a clustered column chart.
2. Drag the date field from your main data table (e.g., Sales[OrderDate]) onto the 'X-axis' field well.
3. Drag your measure (e.g., Sales[Revenue]) onto the 'Y-axis'.
4. Power BI will likely default to summarizing by Year. In the upper-right corner of your visual, you’ll see several arrow icons. Click the double-down arrow ("Go to the next level in the hierarchy") to drill down from Year to Quarter.

This method is quick and easy, but it relies on Power BI's automatic behavior. For more control and robust filtering, the Date Table method is much better.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Building Visuals with Your Date Table Columns (The Best Practice Way)

This is the most reliable and flexible method. You have full control over formatting, sorting, and how dates interact with your entire report.

Using the columns we created earlier in our Date Table:

1. Create a new visual, such as a Line Chart.
2. From your Date Table, drag the Quarter & Year column into the X-axis field well.
3. From your facts table (e.g., Sales or AdSpend), drag your desired measure (like Revenue) into the Y-axis.

That's it! Because you already set up the sorting logic, the line chart will correctly display your revenue for each quarter in chronological order. This slicer-friendly approach allows you to seamlessly filter by year, month, or other date attributes you've added to your Date Table.

Advanced Analysis: Quarterly Comparisons with DAX Time Intelligence

Now that you can show your quarterly data, the next step is to analyze it. A common business requirement is calculating Quarter-over-Quarter (QoQ) growth. This requires a bit of DAX (Data Analysis Expressions), but it’s incredibly powerful.

First, make sure you have a base measure, such as:

Total Revenue = SUM(Sales[Revenue])

1. Calculating Previous Quarter's Revenue

To find the growth, we first need to know what the revenue was in the prior quarter. We use CALCULATE combined with DATEADD for this.

Right-click your Sales table and select New Measure:

Revenue Previous Quarter = CALCULATE( [Total Revenue], DATEADD('Date Table'[Date], -1, QUARTER) )

This formula tells Power BI to take your Total Revenue measure and shift the time period back by one quarter.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Calculating QoQ Growth Percentage

With both current and previous quarter revenue calculated, finding the percentage growth is simple.

Create another new measure:

QoQ Growth % = VAR CurrentQTR = [Total Revenue] VAR PreviousQTR = [Revenue Previous Quarter] RETURN DIVIDE(CurrentQTR - PreviousQTR, PreviousQTR)

(Be sure to click on this new measure and use the Measure tools to format it as a percentage.)

Now, you can create a table and KPI card or combine this with your Quarter & Year column to show exactly how much your revenue has grown or shrunk each quarter. For instance, putting Quarter & Year on the axis of a column chart and QoQ Growth % on the values will instantly visualize your business momentum.

Final Thoughts

Whether you're taking a quick look with the default hierarchies or building powerful growth calculations with DAX, Power BI gives you all the tools you need to analyze your business on a quarterly basis. Building from a solid foundation with a well-structured Date Table is the most important step for getting reliable, flexible results.

Of course, even with a great tool like Power BI, setting up this logic, writing DAX, and connecting data sources can still be a time-consuming manual effort. At Graphed, we believe you shouldn't need to be a data analyst to get powerful insights from your data. Instead of configuring data models and writing DAX formulas, you can simply connect your tools and ask a question in plain English, like "Show me my sales revenue by quarter for the last two years" or "What's our quarter over quarter growth rate?" - and get a live, interactive chart instantly. For a faster way to understand your business performance, check out Graphed.