PL-300 Visualize and analyze the data Practice Question
You want to allow users to filter a report by a specific date range (e.g., last 30 days) without requiring manual selection. Which approach should you take?
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 relative date slicer to the report page.
The correct option is B: add a relative date slicer to the report page. A relative date slicer is a built-in Power BI slicer type that lets users pick dynamic ranges such as 'last 30 days', 'last 3 months', or 'this year', and it automatically recalculates based on the current date without any manual selection. Option A (bookmarks) only switches between pre-defined static views and cannot dynamically follow the current date. Option C (a calculated column flagging the last 30 days) hard-codes a fixed window at refresh time and doesn't give users an interactive range control. Option D (a filter on the date field in the Filters pane) requires users to manually specify explicit start and end dates, which is exactly the manual selection the scenario wants to avoid.
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 bookmarks to switch between fixed date ranges.
Why it's wrong here
Bookmarks capture and restore a predefined view state, including filters and slicer values, but they are authored once and cannot adapt to arbitrary user-selected dates. Clicking a bookmark simply jumps to that fixed snapshot, so it does not provide a freeform or self-service way to specify a date range. Bookmarks are better suited for story-like navigation between known scenarios, not for open-ended date filtering.
- ✓
Add a relative date slicer to the report page.
Why this is correct
A relative date slicer is the correct interactive control because it lets report viewers quickly pick common relative ranges such as Last 30 days, This year, or Yesterday, and it updates dynamically as time passes. Unlike static filters or calculated flags, the slicer places a user-driven filter on the date field and works with any well-formed date column or date table. It requires no DAX and is the standard Power BI pattern for self-service date-range selection.
- ✗
Create a calculated column that flags rows within the last 30 days.
Why it's wrong here
A calculated column that flags rows within the last 30 days is evaluated once when the data is loaded or refreshed, so it becomes stale after a day and cannot react to user interaction. Even if you use a custom date selection, the column stores a fixed value per row and would not change when a user applies a different range. This approach is also inefficient because it adds storage and refresh overhead rather than leveraging Power BI's built-in dynamic filtering.
- ✗
Apply a filter on the date field in the Filters pane.
Why it's wrong here
Applying a filter in the Filters pane is a static, author-defined restriction that applies immediately to the visual or page, but viewers do not have an obvious interactive control to modify it without editing the report. The Filters pane is meant for persistent filters rather than ad-hoc date browsing, and it does not offer the convenient preset ranges and auto-updating behavior of a relative date slicer. It also hides the available date choices from the user because there is no visible selector on the canvas.
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.