Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Easy
Question 21
From the sales table, you create the below bubble chart in Power BI.
Each bubble:
a. is plotted along the axes that represent the average quantity ordered and average sales.
b. plots these average values for a country and product line, with bubble size, indicative of its sales.
You need to display how the relationship between average quantity ordered and average sales changes over several years. What would you do?
-
A
Drag the Year field into the Legend well
-
B
Drag the Year field into the Play Axis well
-
C
From the Analytics pane, add the Median line
Reveal correct answer
Correct answer: B
Explanation
Summary for Revision:
The Play Axis will enable the chart to animate showcasing how the data progresses through time.
Detailed Explanation:
From the chart, it is clear that the average quantity ordered is in the X-Axis well and the average sales is in the Y-Axis well. Also, the Product Line field is in the Legends well. Since each bubble (or square) represents a data point for a combination of Product line and Country, the Country field must be in the Values well.
That’s how a scatter chart is constructed. Further, there are two unused fields: Play Axis and Tooltips. If you add the Year field to the Play Axis well, you can visualize the relationship between the two average values across several years.
Option B is the correct answer.
Reference Link: https://radacad.com/storytelling-with-power-bi-scatter-chart
Product Line is already in the Legends well. You cannot add more than one field into the Legends well. So, if you replace the existing Product Line with the Year field in the Legends well, you get a chart similar to the one below. It doesn’t convey a story of how the relationship changed over several years.
Option A is incorrect.
Adding a median line for either axis help in only understanding where the data is centered. Option C is incorrect.
Reference Link: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#use-the-analytics-pane
PBIX File Link: Visualize relationship between two variables over the years
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
