How to Create a Quarterly Report in Power BI

Creating a quarterly report in Power BI can transform a massive spreadsheet of raw numbers into a clear, interactive story about your business performance. Instead of drowning in rows and columns, you can present your stakeholders with visual insights they can understand in seconds. This guide will walk you through the essential steps to build an effective quarterly report, from connecting your data to designing compelling visualizations.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Before You Open Power BI: Plan Your Report

Jumping straight into Power BI without a plan is a fast track to a confusing and cluttered report. Taking ten minutes to outline your goals first can save you hours of rework later. Before you write a single formula, start by asking a few fundamental questions:

• Who is the audience? A report for the sales team will focus on different metrics than one for the marketing department or the executive board. A sales report might highlight deals closed and pipeline velocity, while a marketing report would feature lead generation and campaign ROI.
• What questions does this report need to answer? The goal of a report isn't to show data, it's to answer questions. Think in terms of what your audience wants to know, such as "How did our revenue compare to last quarter?" or "Which product category was our top performer?"
• What are the key performance indicators (KPIs)? Every team has critical numbers they track. Identify the 3-5 most important metrics that define success for the quarter. These will be the focal point of your report. Common examples include total revenue, customer acquisition cost, conversion rate, or average deal size.

Once you have answers, grab a pen and paper - or a simple drawing tool - and sketch a rough layout. Where will your main KPIs go? How will you show trends over time? This simple wireframe acts as your blueprint, guiding your design process and keeping you focused on what matters.

Step 1: Connecting and Preparing Your Data

Clean, well-structured data is the foundation of any good report. Power BI's Power Query Editor is a powerful tool for getting your data into shape before you start building visuals.

Connecting to Your Data Sources

Power BI can connect to hundreds of different data sources. Whether your data lives in an Excel file on a SharePoint site, a SQL database, or a SaaS platform like Salesforce, the process starts in the same place. On the Home tab of Power BI Desktop, click Get Data and select your source. For this example, let's assume you're connecting to an Excel file containing your company's sales data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Shaping Data with Power Query Editor

Once you've connected to your data source, the Power Query Editor window will open. Think of this as your data-cleaning workshop. It's here that you'll transform your raw data into a usable dataset. Best of all, every step you take is recorded and will be automatically applied every time you refresh your data.

Here are some of the most common data prep tasks for a quarterly report:

• Remove Unnecessary Columns: Your source file might have dozens of columns that aren't relevant to your report. Select the columns you don't need, right-click, and choose Remove Columns to clean up your workspace.
• Correct Data Types: Power BI is usually good at guessing data types, but you should always double-check. Ensure your sales figures are set to a numerical type (like Decimal Number) and your order dates are set to the Date or Date/Time type. This is vital for calculations and time-based analysis.
• Handle Blanks and Errors: Blank cells or errors can break your visuals and calculations. Right-click on a column header and choose Replace Values or Replace Errors to clean them up. For example, replace any 'null' values in a sales column with 0.
• Filter Your Data: You might only need data from the last couple of years for this report. Use the filter dropdown on the date column to filter out older, irrelevant data, making your report faster and more focused.

Once you're satisfied with how your data looks, click Close & Apply on the Home tab to load the cleaned data into your Power BI model.

Step 2: Building a Date Table for Time Intelligence

This is arguably the most important step for any time-based reporting, especially a quarterly report. While your main sales table has a date column, relying on it directly for time intelligence can be messy. Best practice in Power BI is to create a dedicated 'Date' or 'Calendar' table.

A separate Date table allows you to perform powerful time-based comparisons - like Quarter-over-Quarter or Year-over-Year - with simple and efficient formulas known as DAX (Data Analysis Expressions).

Creating a Calculated Date Table with DAX

In the Report View, navigate to the Modeling tab and click New Table. This will open the formula bar where you can enter DAX code to generate your table.

Here's a simple yet powerful formula using CALENDARAUTO(), which automatically scans your entire data model for the earliest and latest dates and creates a continuous list of dates between them:

Date = CALENDARAUTO()

Press Enter, and you’ll have a new table with a single column of dates. Now, let's add some helpful columns to this table that will make our reporting much easier.

While the Date table is selected, use the New Column button on the toolbar to add the following columns:

• Year: Year = YEAR([Date])
• Quarter Number: QuarterNumber = QUARTER([Date])
• Quarter Name: QuarterName = FORMAT([Date], "QQ YYYY") This combines the quarter and year, like "Q3 2024".
• Month Name: MonthName = FORMAT([Date], "mmmm")

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Creating the Relationship

After creating your Date table, you need to connect it to your main data table. Go to the Model View (the third icon on the left-hand navigation pane). Find your Date table and your Sales table. Drag the Date column from your Date table and drop it on top of the date column in your Sales table (e.g., OrderDate). A line will appear between the two, signifying an active relationship. This connection is what allows all your time-based filters and calculations to work.

Step 3: Writing DAX Measures for Your Key Metrics

With our data model set up, it's time to create the calculations that will power our report. In Power BI, these calculations are called measures. Unlike calculated columns, which pre-calculate a value for every row in your table, measures are calculated on the fly based on the context of your filters and visuals. This makes them much more flexible and efficient.

Here are some essential DAX measures for a quarterly report. To create a new measure, right-click on your Sales table in the Fields pane and select New Measure.

1. Total Revenue: The simplest and most important measure. Total Revenue = SUM(Sales[Revenue])
2. Revenue Last Quarter: This is where our Date table shines. The PREVIOUSQUARTER() function makes this analysis incredibly easy. Revenue Last Quarter = CALCULATE([Total Revenue], PREVIOUSQUARTER('Date'[Date]))
3. Quarter-over-Quarter (QoQ) Growth: Now that we have the current and previous quarter's revenue, we can calculate the growth rate. QoQ Revenue Growth = DIVIDE( [Total Revenue] - [Revenue Last Quarter], [Revenue Last Quarter] ) After creating this measure, select it in the Fields pane and use the Measure tools tab at the top to change its format to a Percentage.

You can repeat this pattern for any metric: leads, expenses, site traffic, etc. Create the base measure (e.g., Total Leads), then the "previous quarter" version, and finally the QoQ growth formula.

Step 4: Designing and Visualizing Your Report

This is where your report comes to life. Now you'll use the measures and data tables you've built to create clear and actionable visualizations.

Building the Report Canvas

Start with a clean page and add a title. A good practice is to start with the highest-level information first and allow users to drill down into the details.

1. Add Slicers for Filtering: In the Visualizations pane, select the Slicer visual. Drag the Year field from your Date table into it. Create another slicer for the QuarterName field. This will let your report users easily filter the entire report for the specific time period they want to see.
2. Display Your Main KPIs: Use the Card visual to show your top-line metrics. Create three cards: one for Total Revenue, one for Revenue Last Quarter, and one for your QoQ Revenue Growth percentage. These large numbers immediately answer the most critical questions.
3. Show Trends Over Time: The Line chart is perfect for this. Place the Date from your Date table on the X-axis and Total Revenue on the Y-axis. This visual will clearly show the sales trajectory throughout the quarter.
4. Compare Performance Segments: Use a Clustered bar chart or column chart to break down performance. For example, use it to show Total Revenue by Product Category. This helps identify which areas of the business are performing best.
5. Provide Detailed Data (Optional): A Matrix or Table visual can provide granular data for users who want to see the specific numbers behind the charts. You could show a list of top customers or products ranked by revenue.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Formatting for Clarity

Once your visuals are in place, focus on making them easy to read. Use clear and descriptive titles for each chart (e.g., "Quarterly Revenue Trend" instead of just "Total Revenue"). Align your visuals on a grid to create a clean, professional look, and use color consistently to highlight important information — but avoid using too many clashing colors.

Step 5: Publishing and Sharing Your Report

A report has no value if nobody sees it. Once you're happy with your design, you can share it with your team.

In the Home tab of Power BI Desktop, click Publish. This will push your report to your Power BI Service account online. From there, you can:

• Share the Report: Simply share a link with stakeholders, who can view the interactive report in their web browser.
• Schedule a Refresh: This is a massive timesaver. In the Power BI service, you can set a schedule for your data to automatically refresh (e.g., every morning at 8 a.m.). This ensures your quarterly report is always up-to-date with the latest data, eliminating the need to manually rebuild it.

Final Thoughts

Building a Power BI quarterly report is a fantastic skill that brings clarity and data-driven focus to any team. By following these steps - planning, preparing data, creating a reliable date model and powerful DAX measures, and designing clean visuals - you can move beyond static spreadsheets and create dynamic reports that truly drive decision-making.

While the process in Power BI is powerful, we know it can have a steep learning curve and take considerable time to set up, especially when you feel more like a marketer or sales leader than a data analyst. That's why we built Graphed. Instead of creating DAX measures and designing charts manually, you can simply connect all your sources (like Google Analytics, Shopify, and Salesforce) and describe what you want in plain English. For example, just ask, "Show me a quarterly report comparing revenue and ad spend" and get an interactive, real-time dashboard in seconds, not hours.