PL-300 Visualize and analyze the data Practice Question
You have a Power BI report with a matrix that shows sales by region and product category. Users complain that the matrix is too cluttered and hard to read. Which best practice should you apply to improve readability?
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
✓
Apply conditional formatting using data bars or color scales.
The correct option is D: apply conditional formatting using data bars or color scales. In a matrix showing sales by region and product category, data bars or color scales add a visual encoding that lets users quickly compare magnitudes across cells, reducing the cognitive effort of reading many raw numbers and making patterns stand out. Options A, B, and C do not fit: removing all subtotals and grand totals (A) strips useful aggregation context rather than reducing clutter, adding more hierarchy levels (B) increases granularity and typically makes the matrix denser and harder to read, and converting to a table with all detail rows (C) expands rather than condenses the data, worsening readability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Remove all subtotals and grand totals.
Why it's wrong here
Stripping subtotals and grand totals removes the aggregated figures that make a matrix readable, leaving raw intersecting values with no summarisation. Totals are deliberately removed only when a visual must show unaggregated leaf-level data or when measures are non-additive.
- ✗
Add more hierarchy levels to the rows to provide granularity.
Why it's wrong here
Adding hierarchy levels increases the number of row headers and nested groups rendered in the matrix, compounding the clutter users already reported rather than reducing it. Hierarchies suit drill-down analysis where users need granular exploration of a single dimension, but this scenario calls for decluttering the existing region and category view.
- ✗
Change the matrix to a table with all detail rows.
Why it's wrong here
A table listing every detail row expands the clutter rather than reducing it, since matrices exist to aggregate and collapse detail across two axes. Tables suit flat, single-granularity listings where users need row-level records, not cross-tabulated regional and category summaries.
- ✓
Apply conditional formatting using data bars or color scales.
Why this is correct
Data bars and colour scales encode each cell's magnitude visually, so regional and category patterns stand out without adding rows or columns. This directly reduces the matrix's clutter, the stated readability problem, while preserving all existing values.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.