Power BI Scatter chart

Scatter charts, also known as Bubble chart, shows the relationship between two numerical values.

Using two points of data we consider the chart a Scatter chart, when adding a third point of data then the chart will become a Bubble chart.

We usually use the third point for sizing, which turns the points into a circle with varying sizes based on the data in the size field.

In Scatter charts you can set the number of data points, up to a maximum of 10,000.

Note: Scatter chart does not support data labels, You can only enable category labels for chart. 

Let’s start with an example, download the sample Dataset from below link-

• Global Super Store Dataset

1- Scatter Chart:

Comparing Sales & Profit values with Category & Sub category wise. To plot the scatter chart need two values, so drag Sales & Profit as in X & Y-Axis.

Scatter Chart in Power BI -1

Formatting for Scatter Chart:

You can set the formatting for scatter chart, some important properties are:-

• General: Allows you to set X axis, Y axis, width & height of chart.
• Data colors: Using this section you can change the colors used for each series in the chart.
• X-Axis: Allows you to modify the appearance of the x-axis section of this chart.
• Y-Axis: Using this section allows you to modify the appearance of the y-axis section of this chart.
• Category: Its enables the category name on scatter chart.
• Fill Point: Fill the circle points by colors on chart, if you turned off this it will remove all category colors from circle points on chart.
• Title: Specified the Title name for scatter chart.
• Shapes: Using this you can change the marker shapes & size and you can customize the marker shapes for all category individually.
• Zoom Slider: Enables zoom feature on chart, using this you can easily saw the small values on chart.

Scatter Chart in Power Bi – 2

2 – Bubble chart

A bubble chart replaces data points with bubbles, with the bubble size representing an additional third data dimension.

As you can see here in below screen shot we added third data point “Sales” under Size section, so it will increase the bubble size on the basis of sales volume under each category & subcategory.

Bubble Chart in Power Bi

3 – Data Storytelling with Power BI Scatter Chart

You can create a storytelling data with Scatter chart to using Play Axis feature of chart. Drag date column field here and click to play icon.

Scatter Chart Play Axis

Scatter Chart Play Axis 2

Refer other visuals: Power BI Visualizations

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.