PL-300 Visualize and analyze the data Practice Question
You have a Power BI report that includes a slicer for product category. Users want to select multiple categories and see the combined data. The slicer currently allows only single selection. What should you change?
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
✓
Enable multi-select in the slicer formatting options.
The correct option is D: enable multi-select in the slicer formatting options. In Power BI, the Selection Controls section of the slicer's formatting pane includes a Multi-select toggle (on by default for most slicers), and turning it on lets users Ctrl-click or check multiple product categories so the visual aggregates combined data. Changing the slicer style to dropdown (A) only alters the display, not the selection cardinality, and sync slicers (B) merely propagate an existing slicer's state across pages. Adding a second slicer (C) creates two independent filters that intersect rather than combine categories, so it does not achieve multi-selection.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Change the slicer style to dropdown.
Why it's wrong here
Switching the slicer style to 'Dropdown' only changes the visual presentation of the slicer to a compact drop-down list, which can save space on the canvas. The dropdown style does not alter the underlying selection behavior; without the 'Multi-select' toggle enabled, a dropdown slicer still accepts only a single selection at a time. Consequently, this formatting-only change does not achieve the goal of allowing users to select multiple product categories.
- ✗
Use the sync slicer pane to replicate the slicer on other pages.
Why it's wrong here
The Sync slicers pane in Power BI Desktop replicates the same slicer visual onto other report pages and keeps selections synchronized across those pages. However, it does not change the selection mode of the original slicer; even after syncing, the slicer retains its default single-select behavior unless you explicitly modify the Selection controls in the formatting pane. Therefore, using this pane would not satisfy the requirement to allow selecting multiple product categories simultaneously.
- ✗
Add a second slicer for product category.
Why it's wrong here
Adding a second slicer for product category results in two separate slicer visuals, each of which defaults to single-select mode. If a user picks one category in the first slicer and another in the second, both filter conditions are applied together using AND logic—they do not combine multiple selected categories into a single unified filter. Because the requirement is to enable multi-selection within one slicer, adding a duplicate slicer neither enables multi-select nor provides the intended combined-categories behavior.
- ✓
Enable multi-select in the slicer formatting options.
Why this is correct
In the formatting pane for a slicer, the 'Selection controls' section contains a 'Multi-select' toggle that directly controls whether users can pick more than one value. When this toggle is turned on, users can Ctrl+click (or tap) multiple items—optionally using checkboxes—and the report's visuals will show combined data for all selected product categories. This is the precise, built-in mechanism for enabling multiple selection on a slicer and is the correct fix for the stated requirement.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 524-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.