Expert-led training for your team
Creating a Scatter Chart in Power BI

6 July 2023

Creating a Scatter Chart in Power BI

Creating a Scatter Chart in Power BI

Power BI is an incredibly useful tool for visualising and exploring data in a captivating and interactive manner.

One of the standout features Of Power BI is the ability to create diverse types of charts, including scatter charts.

Scatter charts are perfect for analysing the relationship between two numerical variables and identifying patterns or correlations within the data.

In this Power BI How-to guide, we'll take you through the process of creating a scatter chart in Power BI using Excel data as our data source. You'll learn how to connect your dataset to Power BI, select the relevant data fields, and customize the chart to effectively visualise your data.

By following the step-by-step instructions provided in this guide, you'll gain a solid understanding of how to create and tailor scatter charts in Power BI.

Remember, we are using Excel data for creating a scatter chart.

STEP-1: (Extract data)

  • For this Power BI Excel Connection, you must download a sample Excel Workbook. You can also work with any of your Excel workbooks.
  • Open Power BI Desktop. Navigate to the Home ribbon and click on the Excel option present in the Data section.

 Creating A Scatter Chart in Power BI

  • Go to the folder where you have saved your workbook and click on the Open button after selecting the file.

Creating A Scatter Chart in Power BI



Now, a Navigator window will pop up on your screen. It displays an overview of the data so you can be sure that the range of the data is correct. Now you can load the data by following the below step.

  • Check the box next toSheet1 and click on the Load button.

 Creating A Scatter Chart in Power BI


Once the data source is loaded successfully, we can create our Scatter Chart using the data fields.



First, click on the Scatter Chart under the Visualization section. It automatically creates a Scatter Chart 


 Creating A Scatter Chart in Power BI



To add data to the Power BI Scatter Chart, we must add the required fields:

  • Values: Column that represents the Bubbles.
  • X-Axis:Column that represents the Horizontal Axis.
  • Y-Axis:Column that denotes the Vertical Axis.
  • Legend:Column that sub-divides the Details data.
  • Size: Column that represents the Bubbles’ size.


Next, we must add the English Country/Region to the Values section. You can do this by dragging Country to the Details section, or simply checkmark the Country/Region column.

Creating A Scatter Chart in Power BI

Drag the Sales Amount from the Fields section to the X-Axis section, and Order Quantity to Y-Axis Section.

Creating A Scatter Chart in Power BI 

Next, we need to add Region to the Legend section. Hovering over one of these circles will show information about the Region, Sales, and Total Production Cost.

 Creating A Scatter Chart in Power BI

To demonstrate the Size section of a Power BI scatter chart, we removed the Region from the Legend section and added the Quantity to the Size section.

As you can see from the screenshot below, the circle size has changed as per Quantity.

Creating A Scatter Chart in Power BI

 If you enjoyed reading this Power BI Scatter Graph guide, you may also find our how to guide on Mastering M Scripting Language in Power BI: A Comprehensive Guide, and Power BI: Connecting Power BI to SQL Server. Thanks for stopping by!

+44 (0)20 8446 7555

[email protected]



Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us


Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course