PL-300 Visualize and analyze the data Practice Question
You want to create a report that allows users to select a product category and see the top 5 products by sales within that category. Which approach should you use?
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 slicer for category and apply a Top N filter on product to the visual.
A slicer on category lets users interactively choose the category, while a Top N filter on the product field of the visual dynamically limits the display to the top 5 products by sales within the selected category. This combination directly satisfies the requirement for user-driven category selection and automatic top-5 ranking by the visual's sales measure. Option A does not fit because a waterfall chart with category on the breakdown axis shows contribution changes, not a top-5 product ranking. Option C is less appropriate because a ranking measure alone still requires a visual-level filter to restrict to top 5 and does not by itself provide the category slicer interaction. Option D is not suitable because a calculated column computes rank at data refresh time and cannot respond dynamically to slicer selections or the visual's filter context.
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 waterfall chart with category on the breakdown axis.
Why it's wrong here
Waterfall charts are intended for decomposing a single measure across a sequential breakdown (e.g., time or process steps) and do not offer a native 'Top N' filter for their breakdown axis. Placing category on the breakdown axis would show every product as a step in the waterfall, which is neither sorted by rank nor dynamically limited to the top 5. Moreover, there is no built-in Top N filtering option for waterfall chart's breakdown, so you cannot achieve dynamic ranking per a slicer selection.
- ✓
Add a slicer for category and apply a Top N filter on product to the visual.
Why this is correct
A slicer for category establishes a filter context that the visual's Top N filter respects. When you apply a visual-level Top N filter on the product field (sorted by a measure like Total Sales) and set N=5, the visual re-evaluates the top five products *within the currently selected category*. This works because Top N is applied after slicer filtering in the query pipeline, making the ranking dynamic and context-aware, which is exactly what the user needs.
- ✗
Use a measure to rank products and filter visual to top 5.
Why it's wrong here
Using a measure to calculate a global rank, such as `RANKX(ALL(Products), [Total Sales])`, and then filtering the visual to the top 5 based on this measure, would incorrectly display the top 5 products overall, rather than the top 5 *within* the selected product category. The `ALL` function removes the category filter context, preventing the rank from re-evaluating per category. This approach is tempting because using a measure for ranking is fundamental for advanced filtering, and it would be the correct choice if the requirement was to show the top 5 products across *all* categories, regardless of user selection.
- ✗
Create a calculated column for rank and filter to top 5.
Why it's wrong here
A calculated column for rank is computed once during data refresh and uses row context without any awareness of slicer selections. Filtering your visual to Rank <= 5 will therefore always show the same set of top products based on the entire table, not the top five within the selected category. To make ranking responsive to a slicer, you must use a measure that re-evaluates in the current filter context, but even then you need to apply it via a visual filter or TOPN, not as a calculated column.
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.