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

Building a quarterly sales by territory report from scratch feels like one of those tasks that eats up your entire Monday morning. You know the insights are in there - somewhere - but getting them into a clean, easy-to-read format is a real chore. This guide will walk you through exactly how to create a useful and dynamic sales territory report in Power BI, and then we'll show you how to use its built-in AI features to uncover insights in seconds.

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

Why a Sales Territory Report is Worth Your Time

Before jumping into the step-by-step process, let's briefly touch on why this report is so valuable. It’s more than just a map with numbers, it's a strategic tool. A well-built sales territory report helps you visually pinpoint your strongest and weakest regions, understand where growth is coming from, and allocate resources more effectively. Are your East Coast sales reps outperforming the West Coast team? Is a surprising state suddenly showing a huge spike in sales? This is the report that gives you those answers at a glance.

Consistently reviewing this report helps you:

• Identify High and Low-Performing Regions: Effortlessly see which territories are driving the most revenue and which might need more support, training, or marketing resources.
• Set Realistic Sales Goals: Instead of setting a blanket 10% growth target for everyone, you can tailor quotas based on a territory's historical performance and potential.
• Optimize Resource Allocation: Decide where to hire your next sales rep, launch a new marketing campaign, or invest in regional events based on actual performance data, not just intuition.
• Recognize Market Trends: A new territory might be showing unexpected growth, signaling a new market opportunity you can capitalize on before competitors do.

Step 1: Get Your Sales Data in Order

The quality of your report depends entirely on the quality of your data. Rubbish in, rubbish out. Before you even open Power BI, you need a clean dataset. For a sales territory report, your data usually lives in a CRM like Salesforce or HubSpot, a spreadsheet in Excel or Google Sheets, or directly from your organization’s database.

No matter the source, your goal is to have a simple table with at least these key columns:

• Sale Amount: The value of each transaction (e.g., $5,300). This should be a numerical column.
• Sale Date: The date the sale was closed (e.g., 01/15/2024). This must be formatted as a date.
• Territory: The geographic location of the sale. This could be a country, state, city, or even a custom-defined sales region like "Northeast" or "SoCal."
• Sales Rep (Optional but Recommended): The name of the person who closed the deal. This allows you to drill down into rep performance within a territory.

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

Data Cleaning Best Practices

Before importing your data, take five minutes to scan for inconsistencies. This small step can save you hours of frustration later. Here’s what to look for:

• Consistent Naming: Ensure your territories are spelled uniformly. Power BI sees "CA" and "California" as two different places. Pick one format and stick to it. Use find-and-replace in your spreadsheet to fix any discrepancies.
• Correct Data Types: Make sure your "Sale Amount" column is formatted as a number (currency is fine), not text. Similarly, ensure the "Sale Date" column is formatted as a date. If Power BI sees a date as plain text, it won't be able to group your sales by quarter.
• No Blank Rows: Remove any blank rows within your data, as these can cause errors during import. Blank cells are generally okay, but entire empty rows can break things.

Step 2: Importing Your Sales Data into Power BI

With your clean dataset ready, it’s time to bring it into Power BI. The process is straightforward and Power BI supports connections to hundreds of data sources. For this example, we’ll assume you’re using an Excel or CSV file.

1. On the Power BI home screen, select "Get data."
2. From the common data sources, select "Excel workbook" or "Text/CSV."
3. Navigate to your saved file and click "Open."
4. A "Navigator" window will pop up, showing you the sheets or tables within your file. Select the table containing your sales data and you'll see a preview.
5. Click "Load." If you are completely confident in your data, this will load it directly. However, it's often a good idea to click "Transform Data" instead. This opens the Power Query Editor, a powerful tool for cleaning and shaping data. Even if you don't do anything, it's a good habit to quickly review your columns in this view to ensure the data types (e.g., number, date, text) were interpreted correctly.

Once you're done, click "Close & Apply" in the Power Query Editor. You'll now see your data fields listed in the "Data" pane on the right side of the main Power BI window.

Step 3: Building Your First Report Visuals

This is where the fun begins. We’ll add three core visuals to create our dashboard: a map for geographic context, a bar chart to see quarterly performance, and a table for detailed numbers.

Visual 1: The Sales Territory Map

The most intuitive way to see territory performance is with a map. Power BI makes this simple with its built-in filled map visual.

1. In the "Visualizations" pane, click the "Filled map" icon.
2. A blank map visual will appear on your report canvas. With it selected, go to your "Data" pane and drag your "Territory" field (e.g., State) onto the "Location" field in the Visualization pane.
3. Next, drag your "Sale Amount" field onto the "Color saturation" or "Bubble size" field.

Instantly, you'll see a map where your territories are shaded based on total sales. Darker shades mean higher sales. Just like that, you have a powerful visual overview of your sales landscape.

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

Visual 2: Sales by Quarter Bar Chart

Now, let's track performance over time. A simple column chart works perfectly for this.

1. Click on an empty space on the canvas, then select the "Clustered column chart" icon from the "Visualizations" pane.
2. Drag your "Sale Date" field to the "X-axis" box.
3. Drag your "Sale Amount" field to the "Y-axis" box.

Power BI will automatically create a date hierarchy for you (Year, Quarter, Month, Day). Initially, it might show sales by year. To view it by quarter, look at the X-axis field well and remove "Year," "Month," and "Day" by clicking the 'x' next to them, leaving only "Quarter." You now have a clear chart showing your total sales performance for each quarter.

Visual 3: Detailed Sales Table

Finally, a table gives you the precise numbers behind the visuals. This is useful for stakeholders who want to dig into the details.

1. Select an empty area and click the "Table" icon from the "Visualizations" pane.
2. Drag your "Territory" field into the "Columns" area.
3. Drag your "Sale Amount" into the same "Columns" area. Power BI will add it to the table. You can format this column as currency in the "Data view."

Congratulations! You have the foundation of a great report. Your visuals are interactive, so clicking on a state in your map will automatically filter the quarterly chart and the table to show data for just that state.

Step 4: Using Power BI's AI to Get Deeper Insights

This is where things get really interesting. Instead of spending hours slicing and dicing the data manually, you can use Power BI's AI features to get answers and create narratives for you.

Leverage the Q&A Visual

Don’t know how to build a specific visual but know what you want to ask? The Q&A feature lets you use natural language to create visuals on the fly.

• Simply double-click on any empty part of your report canvas. A popup will appear, allowing you to type a question. Try typing something like:
• As you type, Power BI interprets your question and generates the appropriate visual automatically. If you like the visual it creates, you can click a button to turn it into a standard visual on your report. This is an incredible time-saver and lowers the learning curve significantly.

Find Out "Why" with the Analyze Feature

Let’s say you notice a big spike in sales in Q3 on your column chart. The next logical question is, "Why did that happen?" Instead of manually filtering and searching, let Power BI find the answer for you.

1. In your "Sales by Quarter" chart, right-click on the bar for the quarter you're interested in (e.g., Q3).
2. From the dropdown menu, select "Analyze" and then click "Explain the increase."

Power BI’s AI will analyze all of your other data fields to determine the biggest contributors to that increase. It will then generate a new set of visuals and explanations. For instance, it might show you a "waterfall" chart indicating that the increase was primarily driven by massive sales growth in California and Texas, while other territories remained flat.

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

Automatically Summarize Your Data with Smart Narratives

Finally, the "Smart Narrative" visual saves you the trouble of writing a text summary for your report. It's an AI-powered text box that automatically describes the key takeaways from your visuals.

1. Click on an empty space on the canvas, then select the "Smart narrative" icon in the "Visualizations" pane.
2. Power BI will scan the visuals on the page and generate a paragraph summarizing the data. It might write something like: "At $1.5M, Sale Amount trended up between Q1 and Q3. Across all 4 quarters, Sale Amount ranged from $800k to $1.5M. California accounted for the majority of sales at 35%."

The best part is that this narrative is dynamic. When you filter your report (for instance, by clicking on a specific region on your map), the text automatically updates to reflect the filtered data.

Final Thoughts

With this guide, you now have the steps to not only import data and build a professional-looking quarterly sales territory report, but also leverage Power BI’s AI features to make your analysis faster and smarter. You can move from just reporting numbers to understanding the "why" behind them, all within a single tool.

That said, even a streamlined process in a powerful tool involves setup, cleaning, and a learning curve. We created Graphed to help you skip these steps and get straight to the insights. Instead of manually connecting a CRM, cleaning your spreadsheet, and building each chart, you can just ask questions in plain English like, "create a dashboard showing quarterly sales by state for last year." Our platform automatically connects to sources like Salesforce and Google Sheets, handles the data prep, and uses AI to generate an interactive, real-time dashboard for you in seconds.