PL-300 Visualize and analyze the data Practice Question
You are a Power BI data analyst for an e-commerce company. You have a report with a matrix visual that shows product categories as rows and years as columns, with total sales as values. You want to add a sparkline to each row that shows the trend of sales over the years. What should you do?
⚠ Common exam trap
Many candidates confuse sparklines with small multiples or data bars; sparklines are a built-in feature of matrix visuals, not a separate visual or a formatting option for tables.
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
✓
Add a sparkline to the matrix by enabling 'Sparklines' in the Format pane and adding the Sales measure.
Matrix visuals support sparklines, which can be enabled in the Format pane under 'Sparklines'. You add a measure to plot, and the sparkline appears in each row, showing the trend across the matrix columns. This is the correct method to add sparklines to a matrix without creating separate visuals.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a calculated column to create a text-based trend indicator and display it in the matrix.
Why it's wrong here
A calculated column cannot produce a graphical sparkline; it can only return text or numeric values. Text-based trend indicators are not sparklines and would not visually show the trend as effectively. The requirement is for a graphical sparkline within the matrix.
- ✗
Add a line chart to the report and use the 'Small multiples' feature with Product Category as the small multiples field.
Why it's wrong here
Small multiples would create a grid of line charts, one per product category, but it would not integrate the sparklines into the existing matrix visual. The requirement is to add sparklines to each row of the matrix, not to create a separate visual with multiple charts.
- ✓
Add a sparkline to the matrix by enabling 'Sparklines' in the Format pane and adding the Sales measure.
Why this is correct
Matrix visuals in Power BI support sparklines. In the Format pane, under 'Sparklines', you can turn them on and add a measure (e.g., Total Sales). The sparkline then appears in each row, showing the trend across the columns (years). This is the correct way to add sparklines to a matrix.
- ✗
Convert the matrix to a table visual and enable 'Data bars' for the sales column.
Why it's wrong here
Data bars are horizontal bars that represent the magnitude of a single value, not a trend over time. They would not show the sales trend across years. Also, converting to a table would change the layout, and data bars do not provide sparkline functionality.
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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.