PL-300 Visualize and analyze the data Practice Question
You have a Power BI report connected to a dataset containing a table named Sales with columns OrderDate (date), ProductCategory (text), and SalesAmount (decimal). You create a report page with a line chart showing SalesAmount over OrderDate. Users want to quickly change the date granularity from daily to monthly and also switch between ProductCategory values without editing the report. The page currently has no slicers or filters. You need to add interactive controls that allow users to change the date hierarchy level and filter by product category. What should you do?
⚠ Common exam trap
Candidates often confuse a slicer or parameter with the drill functionality of a date hierarchy, which is the proper way to change granularity on a visual axis.
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 date hierarchy to the line chart's X-axis and add a slicer for ProductCategory.
Using a date hierarchy on the axis enables drill up/down to change granularity, and a slicer on ProductCategory gives users an interactive filter. Both are native Power BI features that require no report editing by consumers. This combination directly addresses the need to switch date levels and filter by category.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a parameter to the dataset that allows switching the date granularity and use a slicer for ProductCategory.
Why it's wrong here
Parameters in Power BI typically refer to Power Query parameters or what-if parameters; they do not provide end-user drill control on a visual axis. A what-if parameter creates a slicer that supplies a value to a measure, but it cannot dynamically change the date hierarchy level on an axis. This approach is overly complex and does not meet the requirement.
- ✓
Add a date hierarchy to the line chart's X-axis and add a slicer for ProductCategory.
Why this is correct
Placing OrderDate as a hierarchy on the X-axis lets users drill down or up between year, quarter, month, and day using the visual's drill controls. A slicer on ProductCategory provides an interactive filter. Together they satisfy the requirement without editing the report, and both are standard Power BI interactive features.
- ✗
Add a hierarchy slicer containing OrderDate and ProductCategory, and place it on the page.
Why it's wrong here
A hierarchy slicer filters data but does not change the granularity of a line chart's X-axis. The line chart would still display at the level defined in the visual, and selecting a date in the slicer would filter rather than drill. This does not allow users to switch between daily and monthly views on the chart itself.
- ✗
Add a page-level filter for ProductCategory and enable the line chart's zoom slider to change date granularity.
Why it's wrong here
Page-level filters are not interactive for report consumers unless they use the filter pane, and they do not allow quick switching of product category. A zoom slider changes the visible range of the axis, not the date hierarchy level. Neither control provides the required granularity switching or easy category filtering.
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 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.