PL-300 Visualize and analyze the data Practice Question
You are working on a Power BI report for a marketing team. The report includes a page with a line chart showing website visits over time, and a table showing the top 5 marketing campaigns by conversion rate. The marketing manager wants to be able to click on a point in the line chart (representing a specific date) and have the table update to show only campaigns that were active on that date. The campaigns data includes a 'StartDate' and 'EndDate'. You have implemented a measure to filter campaigns based on the selected date. However, when you click on a date point in the line chart, the table does not update. What should you do to enable this interaction?
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
✓
In the 'Edit interactions' settings, ensure that the line chart cross-filters the table.
The correct option is D: in the 'Edit interactions' settings, ensure that the line chart cross-filters the table. By default, a visual can filter other visuals on the same page, but if the interaction has been set to None (or Highlight instead of Filter), clicking a date point will not filter the table; setting the line chart to cross-filter the table restores the expected behavior so the measure evaluating StartDate/EndDate against the selected date returns only active campaigns. Option A is wrong because disabling cross-filtering would prevent the table from updating at all. Option B is wrong because drillthrough navigates to a separate drillthrough page rather than filtering the existing table on the same page. Option C is wrong because bookmarks capture static visual states and are not the mechanism for dynamic cross-filtering based on a selected data point.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
In the 'Edit interactions' settings, disable cross-filtering between the line chart and table.
Why it's wrong here
Disabling cross-filtering in Edit interactions severs the data point click propagation from the line chart to the table. The interaction icon changes to 'none', so selecting a date point will not send any filter context to the table, leaving every campaign row visible. Since the requirement is exactly the opposite—clicking a date should shrink the table to campaigns active on that date—this setting prevents the desired behavior.
- ✗
Create a drillthrough page and configure the line chart to drill through to the table page.
Why it's wrong here
A drillthrough page is a separate report page that receives filter context only when the user right-clicks or selects a drillthrough action on a visual that has a drillthrough filter configured. Configuring it would navigate the user away from the marketing report page rather than filtering the table on the same page. The line chart's normal click selection does not trigger a drillthrough, and even if it did, the table on the current page would not respond as required.
- ✗
Add a bookmark for each date and set the line chart to trigger the bookmark on click.
Why it's wrong here
Bookmarks capture a static snapshot of a report page's state, including filters and visibility, but they are not event-driven by visual selections. They can only be invoked manually by a user clicking a bookmark or a button assigned to that bookmark, not automatically by clicking a line chart data point to generate a dynamic filter. Creating one bookmark per date would also be unscalable and would deliver a stale pre-captured state rather than respecting the exact date currently selected.
- ✓
In the 'Edit interactions' settings, ensure that the line chart cross-filters the table.
Why this is correct
In Edit interactions, select the line chart so its interaction icons appear on each target visual, then click the filter (funnel) icon shown over the table to explicitly set the line chart to cross-filter the table. With this enabled, clicking any date point on the line chart sends that date as a filter to the table, showing only campaign rows that are active on that date. This is the direct and correct way to make a selected date in one visual constrain another visual on the same report page.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 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 PL-300 practice question is part of Courseiva's free Microsoft 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 PL-300 exam.