How to Make an X Y Graph in Power BI with AI

Creating an X Y graph, also known as a scatter plot, is one of the best ways to see the relationship between two different numbers. With just a glance, you can tell if your ad spend is actually leading to more sales, or if pricing changes are affecting how many units you sell. This article will show you how to build a clear and informative X Y graph in Microsoft Power BI and then take it to the next level using the platform's powerful, built-in AI features to uncover even deeper insights automatically.

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

What Exactly is an X Y Graph (and Why Should You Care)?

An X Y graph, or scatter chart, is a simple but powerful tool for data visualization. It uses dots to represent the values for two different numeric variables. The position of each dot on the horizontal axis (the X-axis) and the vertical axis (the Y-axis) tells you the value for that specific data point.

In business, this is incredibly useful for spotting correlations and patterns. For example, you can plot:

• Ad Spend (X-axis) vs. Website Conversions (Y-axis): Do more ad dollars actually lead to more conversions?
• Number of Sales Emails Sent (X-axis) vs. Leads Generated (Y-axis): Is there a point of diminishing returns for your email outreach?
• Product Price (X-axis) vs. Units Sold (Y-axis): How does price sensitivity affect your sales volume?

When you look at the collection of points on the graph, you can often see a pattern.

• If the dots generally move from the bottom-left to the top-right, you have a positive correlation (as X increases, Y tends to increase). For example, more time spent studying often leads to a higher exam score.
• If the dots move from the top-left to the bottom-right, you have a negative correlation (as X increases, Y tends to decrease). For example, as the number of available products goes up, the price might come down.
• If the dots are scattered all over the place with no clear pattern, there may be no correlation at all. The price of tea in China likely has no correlation with your website traffic.

Getting Your Data Ready for Power BI

Before you can build any chart, you need to make sure your data is clean and structured properly. This is the single most important step in any reporting process - if you put messy data in, you'll get messy visuals out.

For an X Y graph in Power BI, your data source (like an Excel file or Google Sheet) should ideally have:

• At least two numerical columns: These will be your X and Y variables. Make sure they are formatted as numbers, not text. For example, a column for "Ad Spend" and another for "Revenue."
• An optional dimensional column: This is a text-based column you can use to categorize your data points. For example, you could have a column for "Campaign Name," "Product Category," or "Sales Region." This lets you add more context to the chart.

Here’s a simple example of what your data table might look like for analyzing marketing campaign performance:

In this table, you could easily create an X Y graph comparing "Ad Spend" to "MQLs" to see if your budget is translating into qualified leads.

Once your data is ready, you can load it into Power BI by going to the 'Home' tab, clicking 'Get Data,' and choosing the source (Excel workbook, CSV file, SQL Server, etc.).

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

Step-by-Step: Creating Your X Y Graph in Power BI

Ready to build? Once your data is loaded into Power BI, creating a scatter chart takes just a few clicks. It's much easier than you might think.

Step 1: Select the Scatter Chart Visual

In the Power BI report view, look at the Visualizations pane on the right-hand side. Find the icon that looks like a set of scattered dots - that's the one for the Scatter Chart. Click on it, and a blank chart template will appear on your report canvas.

Step 2: Add Your Data to the X and Y Axes

Now it's time to tell Power BI what data to plot. With the new blank chart selected, look at the fields available in the Visualizations pane just below the icons: you'll see options for X Axis, Y Axis, Legend, and more.

• Drag your independent variable (the one you're controlling or changing) from the 'Data' pane into the X Axis field. Using our example, this would be "Ad Spend ($)".
• Drag your dependent variable (the one you're measuring the effect on) into the Y Axis field. In this case, that would be "MQLs".

The moment you do this, Power BI will plot your data as a single dot. This is because, by default, Power BI is summing all your Ad Spend and all your MQLs. Don't worry, we'll fix that next!

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

Step 3: Break Down the Data with a Legend or Values

To see all your individual data points, you need to tell Power BI how to break them down instead of summarizing everything. You do this by using the 'Legend' or 'Values' field.

• Take your dimensional column - for us, that's "Campaign Name" - and drag it into the Values field.

Instantly, your chart will transform from a single dot into a scatter plot with multiple dots, one for each campaign. Success!

Alternatively, you could drag "Campaign Name" to the Legend field. This will accomplish the same thing but also assign a different color to each campaign, making the chart even easier to read.

Step 4 (Optional): Add More Depth with Bubbles

A scatter plot can tell you about the relationship between two variables, but what if you want to see a third variable? You can do this by turning your scatter chart into a bubble chart.

• Drag another numerical field into the Size well in the Visualizations pane. For instance, dragging the "Clicks" field there will change the size of each dot. Now, the bigger the bubble, the more clicks that campaign generated. You can now see three things at once: spend vs. MQLs vs. clicks.

After a bit of formatting (adding a title, adjusting axes), you have a fully functional and insightful X Y graph!

Unlocking Hidden Insights with Power BI's AI Features

Building the graph is just the starting point. The real magic happens when you let Power BI's AI engine analyze the data for you. With your scatter chart selected, click on the small magnifying glass icon in the Visualizations pane to open the 'Analytics' tab.

1. Automatically Add a Trend Line

A trend line is a straight line that best represents the overall direction of your data. It helps you instantly visualize the correlation.

• In the Analytics pane, expand the Trend Line section and click Add. Power BI immediately draws an AI-generated line through your data points. If it slopes upwards, you have a positive correlation. Sloping down? A negative one.

2. Let AI Find Clusters in Your Data

Clustering is an unsupervised machine learning technique where the AI groups together data points that are similar to each other. In business, this can help you uncover natural customer segments or performance tiers without any manual work.

• To use it, click the 'More options' ellipsis (...) on your visual's corner and select Automatically find clusters. Power BI will ask how many groups it should look for (or you can let it decide).
• After running the analysis, it will color your data points according to the clusters it found. For instance, it might identify a cluster of "high spend, high MQL" campaigns and another of "low spend, low MQL" campaigns. More importantly, it creates a new categorical field ('Campaign Name (clusters)') that you can use to filter and analyze other visuals in your report, providing deep, fast segmentation.

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

3. Use AI to Explain Your Data

Sometimes you'll see a data point that is a clear outlier - a campaign that performed way better or worse than others. Instead of guessing why, you can ask Power BI's AI.

• Right-click on a specific data point and select Analyze > Explain the increase (or decrease, depending on context). Power BI's AI engine will run statistical analysis on all columns in your dataset in the background and pop up a window with several auto-generated charts. These visuals suggest potential drivers for why that specific point is an outlier, often revealing insights you would never have found on your own.

4. Ask Questions with Natural Language Q&A

Finally, a powerful AI feature that changes how you build visuals is the Q&A visual. Instead of dragging and dropping fields, you can just ask Power BI a question in plain English.

• Double-click on an empty space on your report canvas. An 'Ask a question about your data' input box appears. You could simply type:

“show me MQLs by ad spend as scatter Chart”

• As you type, Power BI's natural language processing (NLP) engine interprets what you’re asking for, finds the right data columns, and builds the visual for you on the fly. It's the fastest way to get from a question in your head to an answer on the screen.

Final Thoughts

Creating an X Y graph in Power BI is a quick and effective way to find relationships in your data. It moves you from raw numbers in a table to an immediate visual understanding of performance. By layering on Power BI's intuitive AI tools like clustering and trend lines, you can uncover much deeper insights that help you make smarter business decisions without needing a data science degree.

We built Graphed because we love the power of asking questions with data without getting stuck in the complexity of typical BI tools. Our platform takes the simplicity of AI-powered analysis to the next level by allowing you to connect all your sources - from Google Analytics and HubSpot to Shopify and Facebook Ads - and then just ask a question like "make a dashboard showing my Facebook ad spend vs. Shopify revenue by campaign." Instantly, you get a real-time dashboard that our AI built for you, all without the manual setup. This allows you or your team to focus on insight discovery instead of wasting hours building the same reports over and over again.