DA0-002 Visualization and Reporting Practice Question
An analyst is creating a dashboard in Power BI to track sales performance. They want to ensure that when a user selects a specific product category on a slicer, all other visuals on the page filter to show data only for that category. Which TWO actions should the analyst 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
✓
Edit interactions between the slicer and other visuals to ensure filtering is enabled
In Power BI, slicers by default filter all visuals on a page. However, if the analyst wants to ensure cross-filtering, they can edit interactions to enable filtering. Also, using the 'Sync slicers' pane is for syncing slicers across pages, not for enabling filtering. The 'Filters' pane is for manual filters, not for slicer interactions.
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 the 'Sync slicers' pane to synchronize the slicer across all pages
Why it's wrong here
Syncing slicers is for multiple pages, not for filtering visuals on the same page.
- ✓
Edit interactions between the slicer and other visuals to ensure filtering is enabled
Why this is correct
Correct. This ensures the slicer filters the desired visuals, especially if interactions were previously changed.
- ✗
In the 'Format' pane, set the slicer to 'Single select'
Why it's wrong here
Single select changes the slicer behavior but not the filtering of other visuals.
- ✗
Create a measure using the CALCULATE function with ALLEXCEPT
Why it's wrong here
This would override slicer filtering, not support it.
- ✓
Place the slicer on the page and ensure the category field is added to the slicer
Why this is correct
Correct. A slicer with the category field will filter other visuals by default.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 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 DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.