Scatter and bubble charts in Power BI are valuable for displaying relationships between two sets of quantitative data. They allow you to visualize data as points on a chart where each point represents a combination of x and y numerical values. Here's how to use them:
Scatter Charts:
Scatter charts are used to:
- Display relationships between two numerical values.
- Plot two groups of numbers as a series of x and y coordinates.
- Change the scale of the horizontal axis.
- Turn the horizontal axis into a logarithmic scale.
- Show patterns in large data sets, such as linear or non-linear trends, clusters, and outliers.
- Compare large numbers of data points without considering time.
Steps to create a scatter chart:
- Add the field you want to measure in the Legends section.
- Add the fields you want to measure against on the X-axis or Y-axis.
- Add the values you are measuring and use them to determine the size of the points.
Bubble Charts:
- Bubble charts are a variation of scatter charts with an added dimension. They can be used to visualize three sets of quantitative data, where the size of each bubble represents a third data dimension, such as value or quantity.
- To create a bubble chart, you follow the same steps as for a scatter chart, with the addition of the "Size" parameter, which determines the size of each bubble.
Both scatter and bubble charts help you gain insights into your data by visualizing the relationships between different data points, making them valuable tools for data analysis and visualization.