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.

 

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

 

STEP-2:

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.

 

 

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

 

Step-3:

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

 

 

Step-4:

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.

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

 

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.

 

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.

 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!