PL-300 Visualize and analyze the data Practice Question
You are designing a Power BI report for a sales team. They need to see their individual performance compared to team averages. You have a table with columns: Salesperson, Region, SalesAmount. Which visual best allows each salesperson to see their own value alongside the average?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Combo chart (clustered column and line) with salesperson bars and average line
The combo chart (clustered column and line) with salesperson bars and average line is correct because it plots each salesperson's SalesAmount as a column while overlaying the team average as a line on the same axis, enabling direct individual-versus-average comparison. This dual-axis visual is the standard Power BI approach for comparing categorical values against a reference measure. A clustered bar chart with an average measure would show the average as another bar per salesperson rather than a single team reference, which is misleading. A waterfall chart shows cumulative contributions or changes, not comparisons to an average. A table with conditional formatting can display numbers and color scales but does not visually juxtapose each value against the average as clearly as a combo chart.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Clustered bar chart with a measure for average
Why it's wrong here
A clustered bar chart plots categorical values as horizontal bars; adding a measure for average as a separate value would produce an extra bar or a secondary axis, not a continuous reference line. Power BI's Analytics pane does not offer a constant line for bar charts, so the average cannot be visually superimposed for quick comparison. This forces the viewer to mentally compute or cross-reference, which undermines the goal of instantly spotting above/below-average performers.
- ✗
Waterfall chart
Why it's wrong here
A waterfall chart visualizes sequential additive and subtractive changes across categories or time, emphasizing the cumulative path from a starting to an ending value. It does not support overlaying a constant average baseline, and its axis represents running totals rather than individual category totals. Consequently, comparing each salesperson's total revenue to the overall average would require reading exact values off the chart, which is neither intuitive nor accurate for this comparative scenario.
- ✗
Table with conditional formatting
Why it's wrong here
A table with conditional formatting uses color scales, data bars, or icons to highlight cell values, but it provides no geometric line or axis to represent the average threshold. Color rules can be set to a manual value, yet the viewer must still interpret hues relative to a target without a precise visual anchor. Moreover, small multiples of rows make it difficult to scan multiple salespersons' positions against the average at a glance, so it fails as an effective visual comparison tool.
- ✓
Combo chart (clustered column and line) with salesperson bars and average line
Why this is correct
A combo chart with clustered columns and a line is ideal because Power BI's Analytics pane allows adding an average line directly to the line component, or you can create a constant line measure for the Y-axis. Each salesperson's revenue is represented as a discrete column, while the continuous average line runs horizontally across all categories, making above/below status obvious. The dual structure aligns the column heights with the line's position, giving a clear, unambiguous comparison that bar, waterfall, and table visuals cannot achieve.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.