PL-300 Visualize and analyze the data Practice Test 18 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

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

The map visual does not have a legend field, so clicking does not generate a filter.

Answer

The table visual has a filter that prevents cross-filtering.

Answer

The region slicer is interfering with the cross-filtering.

Question 2

You are a Power BI report creator for a non-profit organization. You have a semantic model with a 'Donations' fact table (columns: 'DonationID', 'DonorID', 'Date', 'Amount', 'CampaignID') and a 'Donors' dimension table (columns: 'DonorID', 'DonorName', 'City', 'DonorType' (Individual/Corporate)). You need to create a report page that shows a scatter chart with 'Total Donation Amount' on the X-axis and 'Number of Donations' on the Y-axis, with each point representing a donor type. You also want to add a trend line to show the correlation. When you create the scatter chart, only one point appears (for all donors combined), instead of separate points for Individual and Corporate. What is the most likely cause?

Accepted Answer

The DonorType field is placed in the 'Values' well instead of the 'Legend' well.. The correct option is B: the DonorType field must be placed in the Legend well so the scatter chart splits into one point per donor type (Individual and Corporate). In Power BI, the Legend well is what creates separate series/points by category, while the Values well holds the numeric measures (Total Donation Amount and Number of Donations). With DonorType in Values, the chart aggregates everything into a single point, which matches the symptom described. Option A is wrong because an inactive relationship would affect filtering/aggregation, not the number of scatter points, and the model already relates Donations to Donors via DonorID. Option C is wrong because SUM and COUNT are appropriate for total amount and donation count, and incorrect aggregation would not by itself collapse categories. Option D is wrong because scatter charts do support multiple categories via the Legend well; small multiples are not required.

Answer

The relationship between Donations and Donors is inactive.

Answer

The measures are incorrectly defined; they should use SUM and COUNT respectively.

Answer

The scatter chart does not support multiple categories; you need to use a small multiples chart.

Question 3

You have a Power BI report connected to a dataset containing a table named Sales with columns OrderDate (date), ProductCategory (text), and SalesAmount (decimal). You create a report page with a line chart showing SalesAmount over OrderDate. Users want to quickly change the date granularity from daily to monthly and also switch between ProductCategory values without editing the report. The page currently has no slicers or filters. You need to add interactive controls that allow users to change the date hierarchy level and filter by product category. What should you do?

Accepted Answer

Add a date hierarchy to the line chart's X-axis and add a slicer for ProductCategory.. Using a date hierarchy on the axis enables drill up/down to change granularity, and a slicer on ProductCategory gives users an interactive filter. Both are native Power BI features that require no report editing by consumers. This combination directly addresses the need to switch date levels and filter by category.

Answer

Add a parameter to the dataset that allows switching the date granularity and use a slicer for ProductCategory.

Answer

Add a hierarchy slicer containing OrderDate and ProductCategory, and place it on the page.

Answer

Add a page-level filter for ProductCategory and enable the line chart's zoom slider to change date granularity.

Question 4

You have a Power BI report with a card visual that displays total sales. Users report that when they apply a date filter using the slicer, the card visual does not update. You have verified that the slicer is properly configured to filter the date table. What is the most likely cause?

Accepted Answer

The card visual is using a measure that ignores filter context, such as one using ALL().. The most common reason a visual does not respond to a slicer is that the measure used in the visual overrides the filter context with functions like ALL() or REMOVEFILTERS(). These functions are often used to calculate percentages of total or to ignore specific filters, but they can inadvertently cause the visual to ignore slicer selections. Checking the measure definition is the first step.

Answer

The card visual is set to 'Do not summarize' for the sales field.

Answer

The slicer is not synchronized with the card visual's page.

Answer

The relationship between the date table and the sales table is inactive.

Question 5

You are creating a Power BI report for a sales team. The report contains a clustered bar chart showing total sales by product category. The sales manager wants to see the exact sales amount for each category without hovering over the bars. You need to configure the visual to display the values directly on the chart. What should you do?

Accepted Answer

Enable the Data labels option in the visual's formatting pane.. Enabling data labels is the direct way to show exact values on a bar chart. It displays the sales amount for each category without any user interaction. This is a built-in formatting feature that requires no additional visuals or measures.

Answer

Add a tooltip page that shows the sales amount when hovering over a bar.

Answer

Change the visual type to a table showing product category and total sales.

Answer

Add a card visual next to the chart that displays the total sales for the selected category.

Question 6

You are creating a Power BI report and need to add a visual that allows users to dynamically change the measure displayed in a chart. Which feature should you use?

Accepted Answer

Field parameters. Field parameters provide a way to let report users choose which measures or dimensions appear in a visual. By adding a field parameter to a slicer, users can select from a list of measures, and the visual updates accordingly. This is the most efficient method to achieve dynamic measure switching without creating multiple visuals or bookmarks.

Answer

Bookmarks

Answer

What-if parameters

Answer

Calculation groups

Question 7

You are a data analyst for a healthcare organization. You have a Power BI report with a clustered bar chart that displays patient counts by department. The report is used by hospital administrators who need to identify which department has the highest patient count. They also want to see the exact patient count for each department without hovering. Which feature should you enable on the visual to meet this requirement?

Accepted Answer

Data labels. Data labels are the correct feature because they display the exact numeric values directly on the visual, allowing administrators to read patient counts without hovering. This meets the need for persistent, at-a-glance information. Other options either require interaction or do not show values.

Answer

Tooltips

Answer

Analytics pane

Answer

Conditional formatting

Question 8

You are a Power BI data analyst for a healthcare organization. You build a report page containing a card visual that displays total patient admissions, a slicer for hospital department, and a table visual listing patient details. A physician selects the 'Cardiology' department in the slicer. She then notices that the card visual updates to show only Cardiology admissions, but the table visual still shows all patients from every department. She wants both visuals to respond to the slicer. What should you do?

Accepted Answer

Edit the interactions for the slicer so that the table visual is filtered by the slicer.. Slicers filter other visuals by default, but individual interactions can be disabled. The table visual's interaction with the slicer was likely set to 'None', so it displays unfiltered data. Using 'Edit interactions' to set the table to be filtered resolves the issue and ensures consistent cross-filtering across the page.

Answer

Add the Department column to the table visual's visual-level filters and set it to 'Cardiology'.

Answer

Change the slicer's selection mode to 'Single select' and enable 'Show Select All'.

Answer

Convert the table visual to a matrix and enable 'Stepped layout'.

Question 9

You are a Power BI data analyst for a healthcare organization. You have a report page with a card visual that displays total patient count. The CEO wants to see the patient count broken down by age group (0-18, 19-35, 36-50, 51-65, 65+) and by gender, with the ability to expand or collapse each age group to see gender details. You need to add a visual that supports this hierarchical drill-down. Which visual should you use?

Accepted Answer

Matrix. A matrix visual is designed for hierarchical data exploration. By placing Age Group and Gender in the Rows section, users can expand or collapse each age group to view gender details. This provides the required drill-down capability. Other visuals either lack hierarchy support or do not allow interactive expansion.

Answer

Treemap

Answer

Clustered bar chart

Answer

Table

Question 10

You are a Power BI data analyst for a manufacturing company. You have a report with a scatter chart that plots production cost (X-axis) versus defect rate (Y-axis) for various production lines. You want to enable users to quickly identify production lines that have both high cost and high defect rate. You decide to add a reference line that divides the chart into quadrants. What should you do?

Accepted Answer

Add a constant line to the X-axis and a constant line to the Y-axis, setting each to the respective average values.. Scatter charts in Power BI allow constant lines on both the X and Y axes. By adding a constant line on each axis at the average values, you create a quadrant view. Points in the upper-right quadrant have both high cost and high defect rate, making them easy to spot. This is the correct approach for quadrant analysis.

Answer

Use the 'Analytics' pane to add a 'Median' line on the X-axis only.

Answer

Create a calculated column that categorizes each production line into a quadrant and use it as a legend.

Answer

Add a trend line and set it to 'Linear' to show the relationship between cost and defect rate.

Question 11

You are a Power BI data analyst for a manufacturing company. You have a report with a line chart showing daily production output over the past year. Users report that the line chart is cluttered and difficult to read due to daily fluctuations. You need to add analytics features to the line chart to help users identify trends and outliers. Which two features should you add? (Choose two.)

Accepted Answer

Trend line. Adding a trend line helps smooth out daily fluctuations and reveals the overall direction of production output. Anomaly detection automatically identifies and highlights unusual data points, making outliers immediately visible. Together, these features make the line chart easier to interpret. Forecast, constant line, and error bars do not directly address the need to identify trends and outliers in historical data.

Answer

Error bars

Answer

Forecast

Answer

Constant line

Question 12

You are a Power BI data analyst for a marketing agency. You create a report with a pie chart showing the percentage of total website traffic by device type (Desktop, Mobile, Tablet). A stakeholder asks you to change the chart so that it shows the actual number of sessions for each device type instead of percentages. What should you do?

Accepted Answer

In the pie chart's format settings, change the 'Detail labels' to display 'Value' instead of 'Percent of total'.. Pie charts display proportions by default, but you can change the data labels to show actual values. In the format settings for the pie chart, under 'Detail labels', you can select 'Value' instead of 'Percent of total'. This makes each slice display the number of sessions for that device type while the slice size still represents the proportion.

Answer

Convert the pie chart to a donut chart and enable 'Show values'.

Answer

Change the visual type to a stacked bar chart.

Answer

Add a card visual next to the pie chart showing the total sessions.

Question 13

You have a Power BI report with a map visual showing sales by city. You want to ensure that cities with higher sales are represented by larger bubbles. What should you do?

Accepted Answer

Place the Sales measure in the Size field well of the map visual.. To size map bubbles by a measure, you place that measure in the Size field well. The map visual then scales the bubbles according to the measure's value. This is the standard way to create proportional symbol maps in Power BI.

Answer

Create a measure that calculates the rank of each city by sales and use it as the Location field.

Answer

Place the Sales measure in the Tooltips field well of the map visual.

Answer

In the map's formatting options, set the Bubble size to 'Sales'.

Question 14

You are a Power BI data analyst for a marketing agency. You have a report page with several visuals that display campaign performance metrics. The page is getting crowded, and you need to provide users with a way to view different sets of visuals without creating multiple report pages. You decide to use bookmarks and a bookmark navigator. What should you do to ensure that users can switch between views seamlessly?

Accepted Answer

Create bookmarks for each view, and in the Selection pane, hide or show the relevant visuals before capturing each bookmark.. Bookmarks capture the current state of a report page, including visual visibility. To create different views on the same page, you hide or show visuals using the Selection pane, then create a bookmark for each configuration. The bookmark navigator provides buttons to switch between these bookmarks. Capturing data or using page navigation does not achieve the desired in-page view switching.

Answer

Use the 'Data' option in the bookmark settings to capture the current filter state for each view.

Answer

Add buttons for each view and configure them to navigate to different report pages.

Answer

Create separate bookmarks for each view, ensuring that the 'Display' option is checked for all visuals.

Question 15

You are a Power BI author for a marketing agency. You have a report with a pie chart showing the percentage of total leads by source. The report is shared with clients who view it on mobile devices. The pie chart's legend is taking up too much space and making the chart small. What should you do to improve the mobile experience?

Accepted Answer

In the mobile layout view, hide the legend and add a custom visual or use data labels to show percentages.. The mobile layout view in Power BI allows you to design a dedicated phone layout. Hiding the legend and using data labels to show percentages reduces clutter and maximizes the chart area. This is the most effective way to improve the pie chart's readability on mobile devices.

Answer

Change the legend position to 'Top' in the visual formatting.

Answer

Convert the pie chart to a donut chart.

Answer

Increase the size of the pie chart on the desktop layout, which will also affect mobile.