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 i
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.