Skip to main content This browser is no longer supported. Show
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Scatter charts, bubble charts, and dot plot charts in Power BI
In this articleAPPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents. You can set the number of data points, up to a maximum of 10,000. When to use a scatter chart, bubble chart, or a dot plot chartScatter and bubble chartsA scatter chart shows the relationship between two numerical values. A bubble chart replaces data points with bubbles, with the bubble size representing a third data dimension.
Scatter charts are a great choice:
In addition to what scatter charts can do, bubble charts are a great choice:
Dot plot chartsA dot plot chart is similar to a bubble chart and scatter chart, but is instead used to plot categorical data along the horizontal axis.
They're a great choice if you want to include categorical data along the horizontal axis. Prerequisites
This tutorial uses the Retail Analysis Sample.
This tutorial uses the built-in Retail Analysis Sample in the Power BI service.
Note Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity. Create a scatter chart
Now let's add a third dimension. Create a bubble chart
Create a dot plot chartTo create a dot plot chart, replace the numerical X Axis field with a categorical field. From the X Axis pane, remove Sales per sq ft and replace it with District > District Manager.
Considerations and troubleshootingYour scatter chart has only one data pointDoes your scatter chart have only one data point that aggregates all the values on the x- and y-axes? Or maybe it aggregates all the values along a single horizontal or vertical line?
Add a field to the Details well to tell Power BI how to group the values. The field must be unique for each point you want to plot. A simple row number or ID field will do.
If you don't have that in your data, create a field that concatenates your X and Y values together into something unique per point:
To create a new field, use the Power BI Desktop Query Editor to add an Index Column to your dataset. Then add this column to your visualization's Details well. Next stepsYou might also be interested in the following articles:
More questions? Try the Power BI Community FeedbackSubmit and view feedback for What type of chart uses one data series to display each value as a percentage of the whole?A pie chart, sometimes called a circle chart, is a way of summarizing a set of nominal data or displaying the different values of a given variable (e.g. percentage distribution). This type of chart is a circle divided into a series of segments. Each segment represents a particular category.
Can a pie chart include more than one series of data?How many series of data can a pie chart include? A pie chart can include only one series of data. What does a pie chart use to represent values? Each value from the series is represented as a slice.
Which is best conveyed using a pie chart?Pie charts are best used for showcasing part-to-whole relationships. In other words, if you have different parts or percentages of a whole, using a pie chart is likely the way to go. Just make sure the total sum equals 100%, or the chart won't make a lot of sense or convey the message you want it to.
Which of the following chart types is used to show data as a percentage of the whole quizlet?A pie chart uses two data series to display each value as a percentage of the whole.
|