How to Find New Customers in Power BI

Power BI is powerful for reporting what’s already happened, but its real value lies in helping you discover what could happen next. Instead of just looking backward at sales history, you can use it to pinpoint exactly who your next best customers are and where to find them. This guide will walk you through how to transform Power BI from a simple reporting tool into a proactive engine for customer growth.

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

Start by Understanding Your Current Best Customers

Before you can find new customers, you need a crystal-clear picture of your current best customers. Finding lookalike audiences and underserved markets all start with analyzing the data you already have. The goal is to build a detailed Ideal Customer Profile (ICP) based on data, not guesswork.

Ask yourself questions like:

• Who are our most profitable customers (highest Lifetime Value)?
• What characteristics do they share? (e.g., industry, company size, geographic location)
• Which marketing channels brought them to us?
• What products or services do they buy most often?
• How frequently do they make purchases?

Your Power BI dashboard will be designed to answer these questions visually, making it easy to spot trends and patterns you’d otherwise miss in a spreadsheet.

Building Your Customer Analysis Dashboard

First, you need to bring your data into Power BI. Strong analysis depends on combining data from different sources to get a complete view of the customer journey.

1. Connect Your Key Data Sources

In Power BI Desktop, go to "Get Data" and connect to your most important business systems. The most valuable insights come from blending these sources:

• CRM Data: This is your goldmine for customer attributes. Connect to sources like Salesforce, HubSpot, or Dynamics 365 to pull in customer names, locations, industries, deal sizes, and lead sources.
• Transactional Data: Connect to your sales database (like a SQL server, Shopify, or even an Excel/CSV export) to analyze purchase history, Average Order Value (AOV), and product preferences.
• Web Analytics Data: Hook up Google Analytics to see which channels are driving traffic and conversions. This helps you understand how customers found you in the first place.

Once connected, you'll use Power Query to clean and model the data, creating relationships between tables (e.g., linking a customer's sales data to their CRM profile using a customer ID or email).

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

2. Create Essential Visualizations for Customer Profiling

Now, let's build the visuals that will bring your Ideal Customer Profile to life. A simple drag-and-drop interface makes this straightforward.

Demographic and Firmographic Breakdown

Understanding who your customers are is step one.

• For B2C: Create a bar chart showing the age distribution of your customers and another one for gender.
• For B2B: Use bar charts to visualize customer distribution by Industry and Company Size.
• Map Visual: Use the map visual to plot customers by city, state, or country. This is often the most revealing chart, helping you instantly see where your core markets are geographically.

Tip: Use a "Card" visual to display your top-performing industry or state as a single, bold number or title.

Behavioral Analysis

Next, focus on what your best customers do.

• Top Customers by Revenue/LTV: A simple table or bar chart showing your top 20 customers by total revenue is always a powerful visual.
• Sales by Product/Service: Use a treemap or funnel chart to show which products generate the most revenue. This helps you identify what your core offering truly is from the customer's perspective.
• Purchase Frequency vs. AOV: A scatter plot is perfect for this. Put Average Order Value on the Y-axis and number of orders on the X-axis. This helps you find your best segment: customers who buy often and spend a lot.

Acquisition Source

Finally, understand how your best customers found you.

• Customers by Lead Source: Create a pie chart or bar chart showing the breakdown of customers by their original lead source from your CRM (e.g., "Organic Search," "Paid Social," "Referral"). This tells you where to invest your marketing budget.

Drilling Down to Define Your Ideal Customer Profile (ICP)

With your dashboard built, you can now act like a data detective. This is where Power BI’s interactivity shines. Click on one visual and watch all the others filter automatically.

Here’s a simple workflow to identify your ICP:

1. On your "Top Customers by LTV" chart, select your top 10% of customers.
2. Observe how the other charts change.

By doing this, you've just used actual data to define your ICP. Your new customer acquisition strategy is now clear: target companies in that industry, in that location, using the marketing channel that has already proven effective.

Identifying Lookalike Audiences and New Markets

Now you can use this ICP to find more people just like them.

Finding Underserved Geographic Areas

Look at your map visual. You likely have hotspots where most of your customers are. But what about the "warm" spots? These are areas where you have a few customers but haven't put in a concentrated effort.

This is low-hanging fruit. You already have a small foothold and proof of concept. You can now use your ICP data to launch targeted ad campaigns (on platforms like Google Ads or LinkedIn) specifically aimed at that city or state, knowing you're targeting a profile that has a high propensity to buy.

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

Expanding Your Product Offerings with Market Basket Analysis

Market basket analysis helps you find relationships between products by answering the question, "what items are most often purchased together?" Finding these product bundles can open up new marketing angles and attract new types of customers.

While complex market basket analysis can be done with Python or R, you can create a simplified version in Power BI using DAX (Data Analysis Expressions). For example, to find out how many times customers who bought "Product A" also bought "Product B," you could create a measure with a DAX formula like this:

Combined Purchase Count = 
CALCULATE(
    DISTINCTCOUNT('Sales'[OrderID]),
    FILTER(
        VALUES('Sales'[OrderID]),
        CONTAINS(
            'Sales',
            'Sales'[Product], "Product A",
            'Sales'[OrderID], EARLIER('Sales'[OrderID])
        ) && CONTAINS(
            'Sales',
            'Sales'[Product], "Product B",
            'Sales'[OrderID], EARLIER('Sales'[OrderID])
        )
    )
)

Even without writing DAX, a simple matrix visual in Power BI can help. Put 'Product Name' on both the rows and columns, and 'Count of Orders' as the values. This creates a correlation matrix that helps you spot popular product pairings to market to new audiences.

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

Forecasting with 'What-If' Parameters

Once you’ve identified a potential new customer segment or market, you can use Power BI's "What-If" parameters to model the potential impact of targeting them.

Go to the Modeling tab and select "New parameter." You can create a slider that allows you to simulate changes in key metrics.

For example, you could create a "Marketing Spend Increase %" parameter. Then, create a new measure that calculates projected new customers:

Projected New Customers = 
( [Current Customers from Channel X] * ('Marketing Spend Increase %'[Marketing Spend Increase % Value]) 
* [Average Conversion Rate] ) 
+ [Current Customers from Channel X]

By connecting this measure to a card visual and playing with the slider, you can get a data-informed estimate of how many new customers you might acquire by increasing your ad spend. This turns your analysis into a powerful planning tool, helping you make the case for investing in a new customer acquisition campaign.

Final Thoughts

Power BI gives you the tools to move beyond surface-level reporting and uncover actionable insights about where your next customers will come from. By integrating your data sources and building visuals that highlight the traits of your best existing customers, you can develop a data-driven strategy for growth.

While Power BI is incredibly capable, it comes with a steep learning curve. Crafting DAX formulas and managing data models can feel like a full-time job. That is precisely why we created Graphed. We connect to all your marketing and sales sources automatically and allow you to build the exact dashboards described here just by using plain English. Instead of learning a complex new tool, you can simply ask, “Show me my top customers by lifetime value, and break them down by industry and location,” and get a live, interactive dashboard in seconds.