Two report elements that let users filter sales to a single selected region

PL-300 By islever Editorial Last updated

Enhance reports for usability and storytelling

Short answer

AC A slicer filters regions directly, and selecting a region in a table cross-filters the line chart; each works alone.

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.
  1. a slicer visual Correct Answer
  2. a drillthrough filter
  3. a table visual Correct Answer
  4. a card visual
  5. a Key Performance Indicator (KPI) visual

Key Takeaways

Both a slicer visual and a table visual achieve the goal in one element: a slicer filters directly, while selecting a row in a table cross-filters the line chart to that region — each works standalone with nothing else to build.

A line chart shows sales for several regions, and the report needs an element through which users can restrict the data to just the region they select, with two complete single-element solutions to identify.

Common mistake: Counting drillthrough as a one-element solution — a drillthrough path requires authoring a separate target page wired with the drillthrough field, which is additional design rather than a single element added to this report.

Expert Analysis

Why the Answer Is Correct

A slicer visual (A) exposes region values that users click to filter every visual on the page, including the line chart, so it fully satisfies the goal on its own. A table visual (C) populated with regions does the same through cross-filtering: selecting a region row filters the line chart to that region. Both are single additions to the existing report page that deliver the required filtering behavior.

Why the Other Options Are Wrong

A drillthrough filter (B) navigates to a different, pre-built target page rather than filtering the current view, and setting it up requires creating that page and configuring the drillthrough field — more than one element, so it fails the 'each correct answer presents a complete solution' framing for this single-page need. A card visual (D) displays one aggregated number and has no mechanism for user selection. A KPI visual (E) also presents an indicator with a target and cannot drive filtering.

Community Comment Notes

The top comment chooses A and C while acknowledging drillthrough could work but requires adding several elements (a new page and visuals), which violates the complete-solution-with-one-element framing. Another comment favors A and B but assumes a geography drill path that the scenario never describes.

Official Reference

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

This link opens the official vendor documentation in a new tab.

Community Votes

AC
63%
AB
37%

63% of anonymous learners picked answer AC. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 17 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 17

  1. RonStrassburg 👍 7
    drillthrough filter is a possible solution but you have to add several elements for this solution (new page, new sales visual on this page). So i go with AC
  2. toussdev 👍 4
    the slicer of course. And .... a table ( with only a column "City" for example)
  3. Florinuca 👍 4
    The selected options are correct. A - Slicer visual B - Drillthrough filter
  4. Palwashai 👍 3
    A & B would have to be the correct answers because "Each correct answer presents a complete solution" and B can be used by itself to accomplish the request.
  5. INDEAVR 👍 3
    A. a slicer visual B. a drillthrough filter
Show 12 more comments
  1. viv1212541 👍 2
    The AB is correct answer lets suppose we have multiple values in column now we possibly select only one value in table then it will show information regarding that row only but if we use slicer then all the summarize info get reflected in visual line chart and similarly in drillthrough we have to put particular column so that it will redraw the line chart
  2. varuns 👍 2
    AB - slicer and drillthrough filter
  3. jaume 👍 1
    Drillthrough filter could work in case there would be a "geography hierarchy" (e.g. Region - City, drilling down you could break down a specific city in its cities) but that would be a hard assumption. With only available details from the question, slicer (option A) and a table with regions in the rows field (with right interactions table - line chart)
  4. SIH007 👍 1
    I think the answer is correct (A/B), and this again is a trick question. Each correct answer is a complete solution. How do you change a table visual to filter to a certain region - you would need the slicer for it, but thats not part of C.
  5. Flix 👍 1
    A/C for A you also need to specify. B? Where will you drill-through from?
  6. noone420 👍 4
    AC correct
  7. nammm112 👍 3
    Slicer and Table Visual
  8. MITZ619 👍 3
    AC are correct options
  9. rcaliandro 👍 2
    AC is the right answer
  10. finlarian 👍 2
    My answer is AC Tested
  11. Valimammadov 👍 2
    javascript:void(0)
  12. malik777 👍 2
    correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

PREVIOUSYEAR returns the full previous year, not the same day of last year

S-grade

Shrinking a Power BI model for monthly transaction totals with a star schema

S-grade

Northwind Traders semantic model: choosing Import storage mode for the Power BI tables

S-grade

Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector

S-grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide