You have a Power B1 report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report…

The goal is to add an interactive element to a report page that allows users to filter a line chart by region.

A slicer visual (A) is the primary tool in Power BI designed specifically for this purpose. It provides an on-canvas filter that users can interact with to select one or more regions, which then filters all other relevant visuals on the page.

A table visual (C) can also be used as a filter. By default in Power BI, visuals are interactive. When a user selects a row in a table (e.g., a row containing a specific region's name), it will cross-filter or cross-highlight other visuals on the same page, including the line chart, effectively filtering them for the selected region.

B. a drillthrough filter: This is a navigation feature that takes a user to a different, more detailed page; it is not a filtering element on the current report page.

D. a card visual: A card visual is designed to display a single, aggregated value. It is not an interactive element and cannot be used to filter other visuals.

E. a Key Performance Indicator (KPI) visual: Similar to a card, a KPI visual displays a single metric against a target and is not designed to be an interactive filter for other report elements.

1. Microsoft Learn. (2023). Slicers in Power BI.

Reference: Under the "When to use a slicer" section

it states

"Slicers are a great choice to... Filter by columns that are unneeded and hidden in the data tables." This confirms a slicer's primary role as an on-canvas filter.

2. Microsoft Learn. (2023). Change how visuals interact in a Power BI report.

Reference: The "Introduction to visual interactions" section states

"By default

visuals on a report page can be used to cross-filter and cross-highlight the other visuals on the page." This principle applies to table visuals

confirming they can act as filters when a user selects a row.

3. Microsoft Learn. (2023). Create card visuals (big number tiles) in Power BI.

Reference: The document describes card visuals as a way to display a single number. It does not mention any capability for the visual to act as a filter source for other visuals

confirming its unsuitability for this task.