Power BI Scatter Chart or Scatter plot is very useful to visualize the relationship between two sets of data.
In this article we will show you, How to Create a Scatter Chart in Power BI with example.
For this Power BI Scatter Chart demonstration, we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Scatter Chart in Power BI
In order to create a Scatter Chart in Power BI, first, Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.
Click on the Scatter Chart under the Visualization section. This will automatically convert a Column Chart into a Scatter Chart.
Let me add the Postal Code to the Details section.
Next, we added the Order Quantity as the Y-Axis. Now you can see the proper Scatter Chart.
Let me do some quick formatting to this Power BI Scatter Chart
Create a Scatter Chart in Power BI Approach 2
First, click on the Scatter Chart under the Visualization section. This will automatically create a Scatter Chart with dummy data as shown in below screenshot.
In order to add data to Power BI Scatter Chart, we have to add required fields:
- Details: Please specify the Column that represent the Bubbles.
- Legend: Specify the Column that will sub-divide the Details data.
- X Axis: Please specify the Column that represent the Horizontal Axis.
- Y Axis: Column that represent the Vertical Axis.
- Size: Specify the Column that represent the Bubbles size.
- Color Saturation: Any Numeric value that will decide the bubbles color.
Let me drag the Sales Amount from Fields section to X Axis section, and Order Quantity to Y Axis Section.
Next, let me add English Country Region Name to Details section. You can do this by dragging Country to Details section, or simply check mark the English Country Region Name column.
Let me add Customer English Occupation to the Legend section. Hover-over any circle will show you the information about the Country, Occupation, Sales Amount, and Total Product Cost.
To demonstrate the Size section of a Power Bi scatter chart, we removed the English Occupation from Legend section, and added the Order Quantity to the Size section.
As you can see from the below screenshot, size of the circle has changed as per the Order Quantity (number of orders)
To demonstrate the Color Saturation section, we added the Sales Amount to the Color Saturation section. As you can see from the below screenshot, color of each circle has changed as per the Sales Amount
Let me do some quick formatting to this Power BI Scatter plot
NOTE: I suggest you to refer Format Scatter Chart article to understand the formatting options.
Thank You for Visiting Our Blog