PL-300 Visualize and analyze the data Practice Question
You are a Power BI consultant for a logistics company. The company has a semantic model with a 'Shipments' fact table (containing 'ShipmentID', 'Date', 'OriginCity', 'DestinationCity', 'Weight', 'Cost') and 'City' dimension table (with 'City', 'Region', 'Country'). The company wants a report that displays a map visual with bubbles sized by total shipment weight, and a slicer to select a region. Additionally, they want to be able to click on a bubble (city) and see a table of shipments from that city. You have implemented a map visual using the 'City' field and a table visual. When you click on a bubble, the table does not filter to show only shipments from that city. You have confirmed that cross-filtering is enabled. What is the most likely cause?
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
✓
The relationship between Shipments and City is based on OriginCity, but the table shows DestinationCity, so the filter does not apply.
The correct answer is C: the relationship between Shipments and City is based on OriginCity, but the table shows DestinationCity, so the filter does not apply. In Power BI, cross-filtering propagates along active model relationships, so clicking a city bubble filters the Shipments table only through the column used by the map's active relationship (OriginCity); if the table visual displays DestinationCity, the filter on OriginCity does not restrict those rows. The fix is to use the same city column in both visuals or add a role-playing dimension/relationship for DestinationCity. Option A is wrong because a legend is not required for a map bubble to act as a filter source. Option B is wrong because a table filter would not silently block cross-filtering unless it explicitly conflicts, and the scenario says cross-filtering is enabled. Option D is wrong because a slicer on Region does not prevent a map selection from filtering the table.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The map visual does not have a legend field, so clicking does not generate a filter.
Why it's wrong here
A legend field is not required for a map visual to send cross-filters. When you click a bubble on a map, Power BI automatically sends a filter on the field(s) bound to the Location well, such as City or Region. The legend only determines visual grouping and color coding; it does not control the cross-filtering behavior, so the absence of a legend is irrelevant to the problem.
- ✗
The table visual has a filter that prevents cross-filtering.
Why it's wrong here
There is no mention of a filter applied to the table visual in the scenario, so this is a speculative explanation. Even if a visual-level filter existed, it would not prevent cross-filtering; it would only restrict the table's rows after the filter is applied, possibly to zero rows, which could mimic a lack of filtering. The actual cause is a mismatch in the field being used for the relationship, not an overt filter on the table.
- ✓
The relationship between Shipments and City is based on OriginCity, but the table shows DestinationCity, so the filter does not apply.
Why this is correct
The map visual is cross-filtering based on the City dimension (e.g., CityName) which is related to the Shipments table via the OriginCity foreign key. However, the table visual displays DestinationCity, which is either a different column in the Shipments table or a different dimension that is not related to the same City table. Because the filter propagates only along active relationships to the fields used in the target visual, the DestinationCity field is not affected, so the table does not update.
- ✗
The region slicer is interfering with the cross-filtering.
Why it's wrong here
Slicers in Power BI act as independent filters on the report page; they do not block or suppress cross-filtering from other visuals. A slicer only constrains the data that is visible in the visuals it affects, but when you click a data point on a map, the cross-filter is still applied to other visuals using the underlying relationship. The propagation of a cross-filter is determined by the data model's relationships and the fields used in the target visual, not by whether a slicer is present.
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.