How to Make Power BI Scatter Charts | Power BI Bubble Charts

FREE Online Courses: Click, Learn, Succeed, Start Now!

1. Objective

In our last Power BI Tutorial, we studied Power BI Treemap. Today, we will learn about when to use a Power BI scatter charts and bubble charts. Moreover, we will study how to make Power BI Scatter Charts and Bubble charts.
So, let’s begin the Power BI Scatter Charts & Bubble Charts.

How to Make Power BI Scatter Charts | Power BI Bubble Charts

How to Make Power BI Scatter Charts | Power BI Bubble Charts

2. Power BI Scatter Charts & Bubble Charts

Power BI Scatter Chart (diagram) dependably has two esteem tomahawks to indicate one arrangement of numerical information along with an even pivot and another arrangement of numerical qualities along with a vertical hub. The outline shows focus at the crossing point of an x and y numerical esteem, joining these qualities into single information focuses. These information focuses might be circulated equally or unevenly over the level hub, contingent upon the information.
Power BI Bubble Chart (diagram) replaces the information focuses on bubbles, with the bubble estimate speaking to an extra measurement of the information.
Do you Know How to Add Power BI Filter in Report

3. When to Utilize Scatter & Bubble Charts in Power BI

a. Power BI Scatter Charts

  • To demonstrate connections between 2 (scatter) or 3 (bubble) numerical qualities.
  • To plot two gatherings of numbers as one arrangement of xy organizes.
  • Rather than a line diagram when you need to change the size of the level hub.
  • To transform the flat hub into a logarithmic scale.
  • To show worksheet information that incorporates combines or assembled sets of qualities. In Power BI scatter charts, you can alter the free sizes of the tomahawks to uncover more data about the gathered qualities.
  • To indicate designs in vast arrangements of information, for instance by demonstrating straight or non-direct patterns, bunches, and exceptions.
  • To look at substantial quantities of information indicates without respect time. The more information that you incorporate into a Power BI scatter charts, the better the correlations that you can make.

b. Power BI Bubble Charts

  • On the off chance that your information has 3 information arrangement that each contain an arrangement of qualities.
  • To introduce money related information. Diverse bubble sizes are helpful to outwardly accentuate particular qualities.
  • To use with quadrants.

Let’s read about How to Create Basic Area Chart in Power BI 

4. How to Create Power BI Scatter Charts?

These guidelines utilize the Retail Analysis Sample. To take after along, download the example for Power BI benefit (app.powerbi.com) or Power BI Desktop.

  1. Select the yellow in addition to a symbol to make a clear report page.
  1. From the Fields sheet, select the accompanying fields:
  • Deals > Sales Per Sq Ft
  • Deals > Total Sales Variance %
  • Area > District
Power BI Scatter Charts | Power BI Bubble Charts

Step – 2  Create Power BI Scatter Charts

In case you’re utilizing Power BI benefit, ensure you open the report in Editing View.

  1. Change over to a scatter graph. In the Visualization sheet, select the Power BI Scatter Charts (diagram) symbol.
  1. Drag District from Details to Legend. This shows a scatter graph that plots Total Sales Variance % along the Y pivot, and plots Sales Per Square Feet along the X hub. The information point hues speak to locale:
Power BI Scatter Charts | Power BI Bubble Charts

Step – 4  Create Power BI Scatter Charts

Presently we should include a third measurement.

5. How to Create Power BI Bubble Charts?

Follow this steps to make bubble chats in Power BI:

  1. From the Fields sheet, drag Sales > This Year Sales > Value to the Size territory. The information guides grow toward volumes proportionate with the business esteem.

Follow this link to know How to Create Power BI Funnel Charts 

Power BI Scatter Charts | Power BI Bubble Charts

Step – 1  Create Power BI Bubble Charts

  1. Drift over a bubble. The measure of the bubble mirrors the estimation of This Year Sales.
Power BI Scatter Charts | Power BI Bubble Charts

Step – 2  Create Power BI Bubble Charts

  1. To set the quantity of information focuses to appear in your bubble diagram, in the Format area of the Visualizations sheet, grow the General card and alter the Data Volume. You can set the maximum information volume to any number up to 10,000. As you get into the higher numbers, we propose testing initially to guarantee great execution.
Power BI Scatter Charts | Power BI Bubble Charts

Step – 3  Create Power BI Bubble Charts

Note – Since more information focuses can mean a more drawn out stacking time, on the off chance that you do distribute reports with limits at the higher end of the scale, make a point to try out your reports over the web and portable also to guarantee execution coordinates your clients’ desires. Note that for higher quantities of information focus, you should test the outcomes on various frame variables to guarantee great execution.
Let’s Explore Power BI Data Sources (Supported) – Connecting Data Source

  1. You can arrange the representation hues, names, titles, foundation, and that’s only the tip of the iceberg. To enhance availability, consider adding marker shapes to each line. Utilizing an alternate Marker shape for each line makes it less demanding for report shoppers to separate lines (or regions) from each other. To choose the marker shape, extend the Shapes card, at that point select a marker shape.
Power BI Scatter Charts | Power BI Bubble Charts

Step – 4  Create Power BI Bubble Charts

You can likewise change the marker shape to a precious stone, triangle, or square:

Step -4   Create Power BI Bubble Charts

So, this was all about Power BI Scatter Charts & Bubble Charts. Hope you like our explanation.

6. Conclusion

Hence, in this Power BI Scatter Charts tutorial, we learned about how to draw Power BI scatter charts. In addition, we learned how to draw bubble charts. Furthermore, if you have any query, feel free to ask the comment box.
Related Topic- Power BI Custom Visualization
For reference

Did we exceed your expectations?
If Yes, share your valuable feedback on Google

follow dataflair on YouTube

1 Response

  1. Naveed Jafri says:

    Is it possible to add secondary Y-axis in a scatter plot?

Leave a Reply

Your email address will not be published. Required fields are marked *