Scatter plots in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a scatter plot used for in Power BI?

A scatter plot shows the relationship between two numeric variables by plotting points on an X and Y axis. It helps find patterns or correlations.

beginner

Which fields do you need to create a basic scatter plot in Power BI?

You need at least two numeric fields: one for the X axis and one for the Y axis. Optionally, you can add a field for size or color to add more detail.

intermediate

How can you add more information to a scatter plot in Power BI?

You can add a 'Details' field to show categories, a 'Size' field to change point size by value, and a 'Legend' field to color points by category.

beginner

What does it mean if points in a scatter plot form a clear upward line?

It means there is a positive correlation: as one variable increases, the other tends to increase too.

intermediate

Why should you avoid using too many points in a scatter plot?

Too many points can make the plot cluttered and hard to read. It’s better to filter or aggregate data for clarity.

What type of data is best for the X and Y axes in a scatter plot?

A Numeric data

B Text data

C Date data only

D Boolean data

Scatter plots require numeric data on both axes to show relationships between values.

In Power BI, which field can you add to change the size of points in a scatter plot?

A Details

B Legend

C Size

D Tooltip

The 'Size' field controls how big each point appears based on a numeric value.

What does a scatter plot help you identify?

A Exact totals

B Data tables

C Text categories

D Trends and correlations

Scatter plots visually show trends and correlations between two numeric variables.

Which Power BI feature helps you see categories by color in a scatter plot?

A Details

B Legend

C Size

D X axis

The 'Legend' field colors points by category to differentiate groups.

What should you do if your scatter plot looks too crowded?

A Filter or aggregate data

B Add more data points

C Remove axes

D Change colors randomly

Filtering or aggregating data reduces clutter and makes the plot easier to understand.

Explain how to create a scatter plot in Power BI and what each field option does.

Think about the roles of axes and how size and color add meaning.

Describe what patterns you might see in a scatter plot and what they mean for your data.

Consider how points line up or group together.