How to Make an X Y Graph in Power BI

Creating an X Y graph in Power BI is one of the quickest ways to see how two different numbers relate to each other. Officially called a scatter chart, this visualization is perfect for spotting trends, finding outliers, and understanding correlations in your data. This article will walk you through exactly what an X Y graph is, why it's so useful for business analysis, and how to build and customize one step-by-step in Power BI.

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 is an X Y Graph (and Why Should You Care)?

An X Y graph, or scatter plot, uses dots to represent the values of two different numeric variables. The position of each dot on the horizontal (X-axis) and vertical (Y-axis) tells you the value for an individual data point. By plotting all your data points, you can see the relationship between the two variables at a glance.

Think of it as the go-to chart for answering questions like, "Does X affect Y?"

• Does ad spend affect revenue?
• Does the number of sales calls affect the number of deals closed?
• Does a product's price affect the number of units sold?

Instead of just looking at totals in a table, a scatter plot gives you a visual gut check on the correlation. You can instantly see if the points trend upwards (a positive correlation, where as X increases, Y increases), downwards (a negative correlation), or are just scattered randomly (no correlation).

Prepping Your Data for a Scatter Plot

Before you jump into Power BI, a quick check of your data structure will save you a lot of headaches. For a scatter plot to work, your dataset needs at least three key ingredients:

1. A column for your X-axis: This must be a numeric value (your independent variable).
2. A column for your Y-axis: This also must be a numeric value (your dependent variable).
3. A column with unique identifiers: This is a descriptive field that represents each individual dot on the graph (e.g., Campaign Name, Product ID, Sales Rep Name, Date).

Here’s what a simple dataset might look like in an Excel or Google Sheet, ready for Power BI:

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

Campaign Name | Ad Channel | Ad Spend | Revenue

Summer Sale | Facebook | $2,500 | $12,000 Q3 Promo | Google | $3,000 | $15,500 Influencer A | Instagram | $1,500 | $8,000 Fall Push | Facebook | $3,500 | $14,000 Holiday Deal | Google | $5,000 | $25,000

With this data, we can plot Ad Spend (X-axis) against Revenue (Y-axis) and see how each individual Campaign Name performed. Once your data is structured, you can load it into Power BI by going to the "Home" ribbon and selecting "Get Data."

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

With your data loaded, you're ready to build the visualization. The process is straightforward, focusing on dragging and dropping the right fields into the right places.

1. Select the Scatter Chart Visual

On the report canvas in Power BI Desktop, 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 you want. Click it to add a blank scatter chart to your report canvas.

2. Add Your X and Y Axis Fields

With the new blank visual selected, you’ll see several “wells” or fields in the Visualizations pane. This is where you tell Power BI which data to use.

• Find your independent variable in the Data pane (e.g., Ad Spend) and drag it into the X-Axis well.
• Next, find your dependent variable (e.g., Revenue) and drag it into the Y-Axis well.

At this point, you might see just a single dot on your chart. This is because Power BI has summed up all your Ad Spend and all your Revenue into one big point. That’s not very useful, which brings us to the most important step.

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

3. Define the Individual Data Points

To break that single dot into many, you need to tell Power BI what each dot should represent. This is handled by the Values field (it might also be called Details depending on your Power BI version).

• Drag the column that uniquely identifies your data points (e.g., Campaign Name) into the Values well.

Now, your chart will spring to life! You’ll see a separate dot for each campaign, correctly positioned based on its unique spend and revenue. You've officially created a Power BI XY graph.

4. Enhance Your Chart with More Dimensions (Optional but Powerful)

What makes scatter charts so powerful is their ability to encode even more information into the visualization. Here are a few ways to add more depth:

• Legend: Want to color-code your dots by category? Drag a categorical field like Ad Channel into the Legend well. Now you can easily compare the performance of Facebook campaigns versus Google campaigns.
• Size: You can add a third numeric value to control the size of each dot. This turns your scatter plot into a bubble chart. For example, you could drag a calculated field like Profit or Return on Ad Spend (ROAS) into the Size well. Bigger bubbles would then represent more profitable campaigns.
• Play Axis: If your data has a time component (like a Date column), drag it into the Play Axis well. This adds an animation control to your chart, allowing you to watch how the relationships between your data points evolve over time. It's a fantastic feature for storytelling.

Customizing Your XY Graph for Maximum Clarity

A default chart gets the job done, but a little formatting goes a long way in making your insights clear and professional. Select your chart, then click the paintbrush icon ("Format your visual") in the Visualizations pane.

General Formatting

Start with the basics under the "General" tab:

• Title: Change the title text to something descriptive, like "Ad Spend vs. Revenue by Campaign." You can also adjust the font, size, and color.
• Effects: Here you can add subtle touches like a background color or border to help your chart stand out on a busy dashboard.

Don’t go overboard, but a clear title is non-negotiable for a good report.

Visual-Specific Formatting

Next, switch to the "Visual" tab for settings specific to the scatter plot:

• Markers: In the "Shape" section, you can change the shape of your dots (circles, squares, diamonds) and adjust their size.
• Colors: Under "Colors," you can set default colors or create rules to change colors based on values. For instance, you could set a rule where any campaign with revenue over $20,000 turns green.
• Axis Labels: Under both X-Axis and Y-Axis, you can bolden the text or change the title to be more specific (e.g., change "Ad Spend" to "Total Ad Spend in USD").
• Category Labels: Toggling this on will display the name of each dot (e.g., the Campaign Name) directly on the chart. Be careful — this can get very cluttered if you have many data points.

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

Adding Analytical Trend Line

Here's where it gets really exciting. In the formatting pane, click the magnifying glass icon ("Add further analysis to your visual"). This is the Analytics pane.

With scatter charts, one of the most useful features is the Trend Line. Click "+ Add" and Power BI will automatically draw a line of best fit through your data points. This line visually shows you the overall trend. Is it upward, sloping downward, or flat? This is immensely helpful for quickly confirming a positive or negative correlation.

You also have the option to add average lines for both the X and Y-axis. Adding both can divide your chart into four quadrants, helping you segment performance. For example:

• Top Right: High ad spend & high revenue (Your Sweet Spot)
• Low Right: Low ad spend & high revenue (Efficient)
• Low Left: Low ad spend & low revenue (Underperformer)
• Top Left: High ad spend & low revenue (Inefficient)

This segmentation can highlight which campaigns need more attention.

Final Thoughts

Scatter charts (X Y graphs) are powerful visualization tools that go beyond simple aggregation to show you the relationship between two variables in an intuitive way. When you master them in Power BI, you can unlock deeper insights — from finding outliers and top performers to determining cause and effect.

If you've ever spent hours wrangling an Excel spreadsheet or struggling with chart buttons and data manipulation, Power BI enables you to remove that complexity. You can simply ask a question in plain English like "Show ad spend vs. revenue as a scatter chart with red markers," and it can easily translate into interactive visual insights. You don't even need to click and drag fields. This can save you time and empower your whole team.

Start your journey today with Graphed for free and start answering your business questions in seconds.