Power BIPowerBI tutorials

Scatter chart in Power BI

Power BIPowerBI tutorials

Scatter chart in Power BI

Power BI Scatter Chart or Scatter Chart is very useful for visualizing the relationship between two sets of data. Let me show you how to create a scatter chart in Power BI with an example.

For this demo of the Power BI scatter chart, we will use the SQL data source that we created in our previous article. Therefore, see the article Connect Power BI to SQL Server to understand the Power BI data source.

How to create a scatter chart in Power BI

To create a scatter chart in Power BI, first drag and drop the Sales Amount section of the fields onto the region of the canvas. Automatically create a column chart, as shown below.

scatter-chart-in-power-bi-1-2088758

Click on the scatter plot below the Display section. Automatically converts a column chart to a scatter chart.

scatter-chart-in-power-bi-2-6023827

Let me add the zip code to the Details section.

scatter-chart-in-power-bi-3-3769937

Next, we add the Order Quantity as the Y-axis. Now you can see the proper scatter plot.

scatter-chart-in-power-bi-4-3145565

Let me apply a quick format to this Power BI scatter chart

scatter-chart-in-power-bi-5-8603000

Create a scatter chart in Power BI approach 2

First, click on the scatter plot below the Display section. Automatically creates a scatter plot with fictitious data, as shown in the following screenshot.

scatter-chart-in-power-bi-6-7279765

To add data to the Power BI scatter chart, we have to add the required fields:

  • Details: Specify the column that represents the bubbles.
  • Legend: Specify the column that subdivides the details data.
  • X axis: Specify the column that represents the horizontal axis.
  • Axis y: Column representing the Vertical Axis.
  • Size: Specify the column that represents the size of the bubbles.
  • Color saturation: Any numerical value that decides the color of the bubbles.

Let me drag the sales amount from the Fields section to the X-axis section and the order quantity to the Y-axis section.

scatter-chart-in-power-bi-7-3981668

Next, let me add the name of the country region in English to the Details section. You can do this by dragging Country to the Details section, or just check the Country Region Name column in English.

scatter-chart-in-power-bi-8-6341728

Let me add Customer's English Occupation to the Legend section. Hover over any circle to display information about country, occupancy, sales amount, and total product cost.

scatter-chart-in-power-bi-9-2615862

To demonstrate the Size section of a Power BI scatter chart, we removed English Occupation from the Legend section. We add the Order Quantity to the Size section.

As you can see from the screenshot below, the circle size has changed based on the Order Quantity (number of orders)

scatter-chart-in-power-bi-10-7358279

To demonstrate the Color saturation section, we add the Sales Amount to the Color Saturation section. As you can see in the following screenshot, the color of each circle has changed based on the Sales Amount

scatter-chart-in-power-bi-11-9318703

Let me quick format this Power BI scatterplot

NOTE: I suggest you refer to the Scatter Chart Format article to understand the formatting options.

scatter-chart-in-power-bi-12-5342003

Power BI Scatter Chart or Scatter Chart is very useful for visualizing the relationship between two sets of data. Let me show you how to create a scatter chart in Power BI with an example.

For this demo of the Power BI scatter chart, we will use the SQL data source that we created in our previous article. Therefore, see the article Connect Power BI to SQL Server to understand the Power BI data source.

How to create a scatter chart in Power BI

To create a scatter chart in Power BI, first drag and drop the Sales Amount section of the fields onto the region of the canvas. Automatically create a column chart, as shown below.

scatter-chart-in-power-bi-1-2088758

Click on the scatter plot below the Display section. Automatically converts a column chart to a scatter chart.

scatter-chart-in-power-bi-2-6023827

Let me add the zip code to the Details section.

scatter-chart-in-power-bi-3-3769937

Next, we add the Order Quantity as the Y-axis. Now you can see the proper scatter plot.

scatter-chart-in-power-bi-4-3145565

Let me apply a quick format to this Power BI scatter chart

scatter-chart-in-power-bi-5-8603000

Create a scatter chart in Power BI approach 2

First, click on the scatter plot below the Display section. Automatically creates a scatter plot with fictitious data, as shown in the following screenshot.

scatter-chart-in-power-bi-6-7279765

To add data to the Power BI scatter chart, we have to add the required fields:

  • Details: Specify the column that represents the bubbles.
  • Legend: Specify the column that subdivides the details data.
  • X axis: Specify the column that represents the horizontal axis.
  • Axis y: Column representing the Vertical Axis.
  • Size: Specify the column that represents the size of the bubbles.
  • Color saturation: Any numerical value that decides the color of the bubbles.

Let me drag the sales amount from the Fields section to the X-axis section and the order quantity to the Y-axis section.

scatter-chart-in-power-bi-7-3981668

Next, let me add the name of the country region in English to the Details section. You can do this by dragging Country to the Details section, or just check the Country Region Name column in English.

scatter-chart-in-power-bi-8-6341728

Let me add Customer's English Occupation to the Legend section. Hover over any circle to display information about country, occupancy, sales amount, and total product cost.

scatter-chart-in-power-bi-9-2615862

To demonstrate the Size section of a Power BI scatter chart, we removed English Occupation from the Legend section. We add the Order Quantity to the Size section.

As you can see from the screenshot below, the circle size has changed based on the Order Quantity (number of orders)

scatter-chart-in-power-bi-10-3548869

To demonstrate the Color saturation section, we add the Sales Amount to the Color Saturation section. As you can see in the following screenshot, the color of each circle has changed based on the Sales Amount

scatter-chart-in-power-bi-11-2379111

Let me quick format this Power BI scatterplot

NOTE: I suggest you refer to the Scatter Chart Format article to understand the formatting options.

scatter-chart-in-power-bi-12-4392940
error: Attention: Protected content.