PL-300 · Question #385
You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to…
The correct answer is A. a slicer visual B. a drillthrough filter. To allow users to filter sales data by region in a Power BI report, you can implement a slicer visual or configure a drillthrough filter.
Question
You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to include only a selected region. Which two elements achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- Aa slicer visual
- Ba drillthrough filter
- Ca table visual
- Da card visual
- Ea Key Performance Indicator (KPI) visual
How the community answered
(33 responses)- A76% (25)
- C12% (4)
- D6% (2)
- E6% (2)
Why each option
To allow users to filter sales data by region in a Power BI report, you can implement a slicer visual or configure a drillthrough filter.
A slicer visual provides an on-report canvas way for users to interactively filter data displayed in other visuals on the same page by selecting specific values, such as regions. This is a common and direct method for user-driven filtering.
A drillthrough filter allows users to right-click a data point in one visual (e.g., a region in a chart) and navigate to another report page, passing the context of the selected region as a filter to the destination page. This enables detailed analysis for a specific region.
A table visual displays data in rows and columns but does not primarily function as a filter mechanism for other visuals.
A card visual displays a single aggregate value, such as total sales, and does not provide filtering capabilities for other visuals.
A KPI visual displays performance against a target and does not serve as an interactive filter for other report elements.
Concept tested: Power BI interactive filtering methods
Source: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-slicers
Community Discussion
No community discussion yet for this question.