How to Create a Quarterly Sales by Territory Report in Power BI

Building a quarterly sales by territory report is a fundamental way to understand where your revenue is coming from and spot regional performance trends. Instead of wrestling with spreadsheet pivot tables, you can create a dynamic, interactive version in Power BI that saves you hours of manual work. This guide will walk you through, step-by-step, how to build a powerful sales territory report from scratch.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Data Preparation: The Foundation of a Great Report

Before you even open Power BI, success starts with your data. A clean and well-structured source file will make the entire process smoother. Your goal is to have a dataset where each row represents a single sales transaction, often called a "flat file."

Required Data Columns

For this specific report, your dataset - whether it's an Excel sheet, a CSV file, or a table in a database - should contain at least these three columns:

• Sale Date: A column with the specific date of each transaction. This is essential for our quarterly analysis.
• Sale Amount: A numeric column containing the value of the sale.
• Territory: A text column that identifies the region or territory the sale belongs to, like "North," "West," or "California."

Helpful Additional Columns

To make your report even more insightful, consider including these columns if you have them:

• Salesperson: The name of the person who closed the deal.
• Product/Service: The name of the item or service sold.
• Customer Name: The client or company who made the purchase.
• Cost of Goods Sold (COGS): If you have this, you can calculate profit margins.

Take a few moments to ensure your column names are clear, your dates are formatted consistently, and you don't have any obvious errors or blank rows. A little cleanup now saves a lot of headaches later.

Setting Up Your Power BI Report

With your data prepped, it's time to fire up Power BI Desktop. We'll start by importing your sales data into a new report.

1. Open a new Power BI file.
2. On the Home ribbon, click the Get Data dropdown. Power BI gives you dozens of options to connect to data sources.
3. Choose the connector that matches your data source. For this example, we'll assume the data is in an Excel workbook. Select Excel workbook.
4. Navigate to your saved file and click Open.
5. The Navigator window will appear, showing you the different sheets or tables within your file. Check the box next to your sales data table.
6. A preview will load. Click the Load button. Power BI will pull your data into its data model.

You can see your loaded table in the Data pane on the right-hand side of the screen.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why You Need a Dedicated Date Table

This is one of the most important best practices for anyone working with time-based data in Power BI. While Power BI has some built-in date intelligence, creating a separate "Date Table" gives you much more control and power for your analysis.

A Date Table, or calendar table, is a table that contains a row for every single day over a given period. It allows you to reliably compare time periods, like this quarter versus last quarter, and build flexible filters for years, months, and days.

Creating a Date Table with DAX

Don’t worry, you don’t have to build one manually. You can generate a comprehensive Date Table in seconds using DAX (Data Analysis Expressions), Power BI's formula language. It's like a superpower for your reports.

1. Go to the Modeling tab in the main ribbon.
2. Click on New Table.
3. A formula bar will appear. Enter the following DAX formula. This tells Power BI to create a table with a single column called "Date" that includes every day from the earliest sale date in your data to the latest. Make sure to replace 'Sales Data'[Date] with the actual name of your sales table and date column.

Date Table = CALENDAR(MIN('Sales Data'[Date]), MAX('Sales Data'[Date]))

1. Hit Enter. A new table called "Date Table" appears in your Data pane.

Adding Useful Columns to Your Date Table

Now, let's add columns for Year, Quarter, and Month to make reporting easier.

1. With your "Date Table" selected, go to the Modeling tab and click New Column.
2. Enter this formula for the year:

Year = YEAR('Date Table'[Date])

1. Repeat the process, adding columns for the quarter and month name:

• For the quarter (This will give you "Q1", "Q2", etc.):

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

• For the month name:

Month = FORMAT('Date Table'[Date], "mmmm")

Finalizing Your Date Table

There are two quick but vital steps left:

1. Mark as Date Table: Select your "Date Table." In the Table tools menu, click Mark as date table, and select the Date column when prompted. This tells Power BI which column to use for its built-in time intelligence.
2. Create a Relationship: Go to the Model View on the left-hand pane (it looks like three connected boxes). Click and drag the Date field from your "Date Table" and drop it onto the sales transaction date field (e.g., SaleDate) in your "Sales Data" table. A line will appear between them, confirming the relationship.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Creating Key Sales Measures

Measures are calculations that you perform on your data. Instead of adding calculated columns to your table, measures are calculated dynamically based on what you’re looking at in your report. This is where DAX really shines.

Let's create the measures we need to analyze quarterly sales performance.

Total Sales

First, an easy one. We need a measure to sum our sales revenue.

1. Right-click on your "Sales Data" table in the Data pane and select New Measure.
2. Enter this formula:

Total Sales = SUM('Sales Data'[Revenue])

1. Remember to replace 'Sales Data'[Revenue] with the correct table and column name from your data. You’ll usually want to format this as currency. With the measure selected, go to the Measure tools ribbon and change the format to Currency.

Sales in the Previous Quarter

To calculate growth, we need to know what our sales were in the prior quarter. Time intelligence functions make this simple.

Sales Last Quarter = CALCULATE([Total Sales], PREVIOUSQUARTER('Date Table'[Date]))

Quarter-over-Quarter Growth %

Now we can calculate the percentage change from one quarter to the next. The DIVIDE function is great because it automatically handles any potential "divide by zero" errors.

QoQ Growth % = DIVIDE(([Total Sales] - [Sales Last Quarter]), [Sales Last Quarter])

Don't forget to format this measure as a Percentage by selecting it and using the Measure tools ribbon.

Building Your Report Visuals

This is where your work comes to life! We'll add several visuals to our report canvas to tell a clear story about our territorial sales performance.

1. Sales by Territory and Quarter (Matrix)

The matrix visual is perfect for this. It's essentially a pivot table, placing your territories on rows and time periods on columns.

1. Select the Matrix visual from the Visualizations pane.
2. Drag Territory from your "Sales Data" table into the Rows field well.
3. From your "Date Table," drag Year and Quarter into the Columns field well. This creates a hierarchy you can expand and collapse.
4. Drag your [Total Sales] measure into the Values field well.
5. To make it easier to read, select the visual, go to the Format your visual panel, find Cell elements, turn on Data bars for the Total Sales series. This adds horizontal bars to each cell, giving you a quick visual reference for performance.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Sales by Territory (Map)

A map visual provides an immediate geographic context to your sales data.

1. Select the Map visual (the one that looks like a globe).
2. Drag your Territory field into the Location field well. If your territories are well-defined places like states or countries, Power BI will map them.
3. Drag [Total Sales] into the Bubble size field well. Larger bubbles will represent higher sales.

3. Quarter-over-Quarter Growth (Column Chart)

This chart clearly shows your growth trajectory over time.

1. Select the Stacked column chart visual.
2. Drag your [QoQ Growth %] measure into the Y-axis field.
3. From your "Date Table," drag Year and Quarter into the X-axis field.
4. You now have a bar chart showing positive and negative growth each quarter.

4. Slicers for Interactivity

Slicers are filters that anyone viewing the report can use to drill down into the data.

1. Select the Slicer visual.
2. Drag Year from your "Date Table" into the slicer's Field well.
3. Adjust the formatting to be a dropdown or list if you prefer.
4. Create another slicer and add the Territory field. Now, you or your sales lead can review performance for specific years or territories with a single click.

Arrange your visuals on the canvas, add a title using a Text Box, and make any final formatting tweaks to align everything. When you're happy, you can click the Publish button on the Home ribbon to share it with your team through the Power BI service.

Final Thoughts

By preparing your data, creating a robust date table, writing a few key DAX measures, and arranging clear visuals, you can build a quarterly sales report that provides immediate and actionable insights for your team. This report no longer needs to be a static spreadsheet, it's now a dynamic tool for understanding your business.

Going through all these steps in Power BI is a powerful skill, but we know it can be time-consuming. We built Graphed because we wanted to go from raw data to a finished report without writing DAX formulas or arranging visuals manually. You can connect your data source and simply ask it in plain English: "Create a dashboard showing our quarterly sales by territory for the last two years with a QoQ growth chart." Graphed instantly builds the report for you, using live data, transforming hours of setup into seconds.