This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Create reports
      --> Apply Slicing and Filtering

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

---

Practice Questions

Question 1

A report page contains multiple visuals. Only one chart should be filtered to show data for the “West” region.
Which filtering approach should you use?

A. Report-level filter
B. Page-level filter
C. Visual-level filter
D. Slicer

Correct Answer: C

Explanation:
Visual-level filters affect only the selected visual, making them ideal when filtering should not impact other visuals on the page.

---

Question 2

You want users to interactively filter report visuals by selecting values from a dropdown on the report canvas.
Which feature should you use?

A. Page-level filter
B. Visual-level filter
C. Slicer
D. Drillthrough

Correct Answer: C

Explanation:
Slicers are visible, interactive controls that allow users to filter visuals dynamically.

---

Question 3

A filter must apply to all visuals on every page in the report.
Which filter scope should be used?

A. Visual-level
B. Page-level
C. Report-level
D. Drillthrough

Correct Answer: C

Explanation:
Report-level filters apply across the entire report, affecting all pages and visuals.

---

Question 4

Users should be able to right-click a value in a visual and navigate to a detail page that shows related information.
Which feature enables this?

A. Page-level filter
B. Cross-highlighting
C. Drillthrough
D. Slicer

Correct Answer: C

Explanation:
Drillthrough filters pass the selected context to another report page, enabling detailed analysis.

---

Question 5

A date slicer should always show dynamic options such as “Last 7 days” or “Last 30 days.”
Which filtering type supports this requirement?

A. Basic filtering
B. Relative date filtering
C. Advanced filtering
D. Top N filtering

Correct Answer: B

Explanation:
Relative date filtering allows time-based filtering that updates automatically as time passes.

---

Question 6

A bar chart should display only the top 5 products by revenue.
Which filter type should you use?

A. Basic filter
B. Relative date filter
C. Advanced filter
D. Top N filter

Correct Answer: D

Explanation:
Top N filtering limits displayed values based on a measure, such as revenue.

---

Question 7

A slicer is added to a report page, but one visual should ignore its selection.
What should you configure?

A. Visual-level filter
B. Edit interactions
C. Report-level filter
D. Drillthrough field

Correct Answer: B

Explanation:
Edit interactions allows you to control how slicers affect individual visuals, including disabling interactions.

---

Question 8

Which scenario is best suited for using a slicer rather than a filter pane?

A. Applying a fixed filter that users should not change
B. Hiding irrelevant data across the entire report
C. Allowing users to explore different categories dynamically
D. Enforcing security rules

Correct Answer: C

Explanation:
Slicers are designed for user-driven, interactive exploration of data.

---

Question 9

Clicking a data point in one visual highlights related values in another visual without removing unrelated data.
What is this behavior called?

A. Cross-filtering
B. Drillthrough
C. Cross-highlighting
D. Basic filtering

Correct Answer: C

Explanation:
Cross-highlighting emphasizes related data points while keeping the full dataset visible.

---

Question 10

Which best describes the primary purpose of slicing and filtering in Power BI?

A. Improve data refresh speed
B. Restrict data at the source
C. Enable interactive data exploration
D. Create calculated fields

Correct Answer: C

Explanation:
Slicing and filtering allow users to explore subsets of data interactively, improving insight and usability.

---

Go back to the PL-300 Exam Prep Hub main page