How to Create Scatter Chart in Power BI: Step-by-Step Guide

To create a scatter chart in Power BI, select the Scatter chart visual from the Visualizations pane, then drag your numeric fields to the X Axis and Y Axis wells. Optionally, add a field to Details or Legend to differentiate data points.

Syntax

A scatter chart in Power BI requires at least two numeric fields: one for the X Axis and one for the Y Axis. You can also add optional fields for Details (to show individual points), Legend (to color points by category), and Size (to vary point size).

• X Axis: Numeric field for horizontal position.
• Y Axis: Numeric field for vertical position.
• Details: Field to identify each point uniquely.
• Legend: Categorical field to color points.
• Size: Numeric field to control point size.

power_bi

Scatter chart visual:
- X Axis: Numeric field
- Y Axis: Numeric field
- Details: (optional) Unique identifier
- Legend: (optional) Category
- Size: (optional) Numeric for bubble size

Example

This example shows how to create a scatter chart using sample sales data with Sales Amount on the X Axis and Profit on the Y Axis. The Product Category is used as the Legend to color points by category.

power_bi

1. Open Power BI Desktop.
2. Load your data (e.g., Sales table with fields: Sales Amount, Profit, Product Category).
3. Click on the Scatter chart icon in the Visualizations pane.
4. Drag <code>Sales Amount</code> to <code>X Axis</code>.
5. Drag <code>Profit</code> to <code>Y Axis</code>.
6. Drag <code>Product Category</code> to <code>Legend</code>.
7. Optionally, drag <code>Order ID</code> to <code>Details</code> to show individual points.
8. Adjust formatting as needed (titles, colors).

Output

A scatter chart appears showing points positioned by Sales Amount (horizontal) and Profit (vertical), colored by Product Category.

Common Pitfalls

• Not using numeric fields for X and Y axes causes the scatter chart to not display properly.
• Missing Details field can cause points to aggregate and overlap, hiding individual data points.
• Using too many categories in Legend can clutter the chart and reduce readability.
• Not adjusting axis scales or labels can confuse viewers.

power_bi

Wrong way:
- X Axis: Text field (e.g., Product Name)
- Y Axis: Numeric field
Result: Chart may not render points correctly.

Right way:
- X Axis: Numeric field (e.g., Sales Amount)
- Y Axis: Numeric field (e.g., Profit)
- Details: Unique identifier (e.g., Order ID)

Quick Reference

Field	Purpose	Example
X Axis	Numeric value for horizontal position	Sales Amount
Y Axis	Numeric value for vertical position	Profit
Details	Unique identifier for each point	Order ID
Legend	Category to color points	Product Category
Size	Numeric value to vary point size	Quantity Sold

Key Takeaways

Use numeric fields for both X and Y axes to create a valid scatter chart.

Add a Details field to show individual data points clearly.

Use Legend to color points by category but avoid too many categories.

Adjust axis titles and scales for better readability.

Scatter charts visualize relationships between two numeric variables effectively.