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

Question 1

You want to create a report that allows users to select a product category and see the top 5 products by sales within that category. Which approach should you use?

Accepted Answer

Add a slicer for category and apply a Top N filter on product to the visual.. A slicer on category lets users interactively choose the category, while a Top N filter on the product field of the visual dynamically limits the display to the top 5 products by sales within the selected category. This combination directly satisfies the requirement for user-driven category selection and automatic top-5 ranking by the visual's sales measure. Option A does not fit because a waterfall chart with category on the breakdown axis shows contribution changes, not a top-5 product ranking. Option C is less appropriate because a ranking measure alone still requires a visual-level filter to restrict to top 5 and does not by itself provide the category slicer interaction. Option D is not suitable because a calculated column computes rank at data refresh time and cannot respond dynamically to slicer selections or the visual's filter context.

Answer

Use a waterfall chart with category on the breakdown axis.

Answer

Use a measure to rank products and filter visual to top 5.

Answer

Create a calculated column for rank and filter to top 5.

Question 2

You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?

Accepted Answer

Add latitude and longitude fields to the map visual.. The correct option is B: add latitude and longitude fields to the map visual. Power BI's built-in map relies on geocoding city names, and ambiguous or duplicate city names across regions often fail to plot, so supplying explicit latitude and longitude values gives the visual unambiguous coordinates to render each store location. Option A is unnecessary because switching to the ArcGIS Map visual does not resolve missing geocoding data. Option C is irrelevant since a filled map still depends on the same geocoding and would not fix missing points. Option D is not the issue because the scenario already confirms the city names are correct, and a text data type is expected for city fields anyway.

Answer

Use ArcGIS Map visual instead of the built-in map.

Answer

Change the map visual to a filled map.

Answer

Ensure the city column is set to the Text data type.

Question 3

Which THREE actions can you take to improve the performance of a slow Power BI report that uses multiple visuals on a single page?

Accepted Answer

Use the Performance Analyzer to identify and optimize the slowest visuals.. Option B is correct because the Performance Analyzer in Power BI Desktop records the DAX query, visual display, and other timing metrics for each visual, letting you pinpoint exactly which visuals are slowest and target optimization efforts. Option D is correct because each field added to a visual increases the size of the DAX query result and the rendering work, so trimming visuals to only the necessary fields reduces query and render time. Option E is correct because cross-filtering and cross-highlighting force dependent visuals to re-query and re-render whenever a selection is made, so disabling interactions between unrelated visuals cuts unnecessary query and rendering overhead. Option A is not correct because refresh frequency affects data latency and load on the source, not the rendering performance of a report page. Option C is not correct because adding more calculated measures generally increases model complexity and query cost rather than precomputing aggregations; pre-aggregation is achieved through import mode, aggregation tables, or summary tables, not by adding calculated measures.

Answer

Increase the frequency of data refreshes to reduce data latency.

Answer

Add more calculated measures to precompute aggregations.

Question 4

Refer to the exhibit. You have a Power BI measure defined as shown. Users report that when they filter by region, the measure always shows sales for the North region regardless of the filter. What is the most likely cause?

Accepted Answer

The filter argument in CALCULATE overrides the existing filter context on Region.. The CALCULATE function includes a filter argument that overrides any existing filter context on the Region column. Option B is wrong because SUM does not ignore filters. Option C is wrong because the measure syntax is valid. Option D is wrong because the filter is on Region, not on the entire table.

Answer

The SUM function ignores filters applied to the Sales table.

Answer

The measure syntax is invalid and defaults to no filter.

Answer

The filter is applied to the entire Sales table, not just the Region column.

Question 5

You are creating a Power BI report and need to visualize the relationship between two numerical variables, such as sales amount and profit. Which visual type is most appropriate?

Accepted Answer

Scatter chart. The correct option is D, a scatter chart, because it plots each observation as a point on a two-dimensional plane with one numerical variable on the X-axis (e.g., sales amount) and the other on the Y-axis (e.g., profit), directly revealing correlation, clusters, and outliers between the two measures. Line charts are designed to show trends of a measure over a continuous axis such as time, not the relationship between two independent numerical variables. Stacked bar charts compare categorical values and show part-to-whole composition, and pie charts display proportions of a single categorical field, so neither can express the pairwise correlation of two numeric measures.

Answer

Line chart

Answer

Stacked bar chart

Answer

Pie chart

Question 6

You have a Power BI dataset that contains a table with sales data and a separate date table. You need to create a measure that calculates the total sales for the previous month relative to the selected date. Which DAX function should you use?

Accepted Answer

PREVIOUSMONTH. PREVIOUSMONTH (option C) is correct because it is a time-intelligence function that returns a single-column table of dates for the entire month immediately preceding the dates in the current filter context, so wrapping it in CALCULATE with SUM of sales yields the previous month's total sales. It works directly against a marked date table and shifts the context back exactly one month, which matches the requirement. SAMEPERIODLASTYEAR shifts the context back one year, not one month, so it would return the same period last year. DATEADD shifts dates by a specified number of intervals but requires an explicit interval argument and is more general, not purpose-built for the immediately preceding month. PARALLELPERIOD shifts by a specified number of intervals and returns a full period, but it also requires an interval argument and is not the specific previous-month function.

Answer

SAMEPERIODLASTYEAR

Answer

DATEADD

Answer

PARALLELPERIOD

Question 7

You have a Power BI report that includes a slicer for product category. Users want to select multiple categories and see the combined data. The slicer currently allows only single selection. What should you change?

Accepted Answer

Enable multi-select in the slicer formatting options.. The correct option is D: enable multi-select in the slicer formatting options. In Power BI, the Selection Controls section of the slicer's formatting pane includes a Multi-select toggle (on by default for most slicers), and turning it on lets users Ctrl-click or check multiple product categories so the visual aggregates combined data. Changing the slicer style to dropdown (A) only alters the display, not the selection cardinality, and sync slicers (B) merely propagate an existing slicer's state across pages. Adding a second slicer (C) creates two independent filters that intersect rather than combine categories, so it does not achieve multi-selection.

Answer

Change the slicer style to dropdown.

Answer

Use the sync slicer pane to replicate the slicer on other pages.

Answer

Add a second slicer for product category.

Question 8

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

Accepted Answer

Analytics pane in the visual. The Analytics pane in the visual (option D) is the correct feature because Power BI provides built-in trend line support there; selecting the visual, opening the Analytics pane, and adding a Trend line overlays a linear regression line on the line chart to show the overall direction of sales over time. The Forecast option (option A) is also in the Analytics pane but is designed to project future values using exponential smoothing, not to display a historical trend line. Writing a DAX measure for linear regression (option B) is unnecessary and more complex since Power BI already offers a native trend line, and the Format pane (option C) only changes cosmetic line styling such as color, width, or dash type, not the trend calculation.

Answer

Forecast option in the visual

Answer

Add a DAX measure for linear regression

Answer

Format pane to change line style

Question 9

You are creating a Power BI report to analyze customer churn. You have a table with Customer ID, Churn Date, and other attributes. You want to create a measure that calculates the number of customers who churned in the last 30 days. Which THREE components do you need?

Accepted Answer

A measure using CALCULATE, COUNTROWS, and DATESINPERIOD. Option D is correct because time-intelligence functions like DATESINPERIOD require a dedicated Date table that is marked as a date table, ensuring a continuous, unbroken date range for accurate period calculations. Option C is correct because the Date table must be related to the Churn Date column in the fact table, which is what allows the filter context from the date table to propagate to the churn records. Option A is correct because the measure itself is built with CALCULATE to modify filter context, COUNTROWS to count the churned customers, and DATESINPERIOD to return the set of dates covering the last 30 days. Option B is not needed because a calculated column flag is static and evaluated at refresh, and it cannot respond dynamically to slicers or report filter context the way a measure does. Option E is not needed because a disconnected table with a date range would not filter the fact table through a relationship, so it cannot drive the time-based calculation correctly.

Answer

A calculated column for 30-day flag

Answer

A disconnected table with date range

Question 10

You have a Power BI report that displays sales data by region. The report includes a map visual showing sales amount by state. You notice that some states are not displayed on the map because the state names in the data do not match the standard names used by Power BI's map visualization. For example, 'California' is correct but 'CA' is not recognized. You need to ensure all states appear correctly. Which action should you take? A. Create a calculated column that maps state abbreviations to full names using a SWITCH statement. B. Change the map visual to a filled map. C. Use the 'Data category' property to set the field to 'State or Province'. D. Add a custom map image. Which option is the best?

Accepted Answer

Create a calculated column that maps state abbreviations to full names using a SWITCH statement. The scenario describes a data-quality problem: the state field contains values like 'CA' that Power BI's map engine cannot geocode, so a calculated column using SWITCH (or a lookup table) must translate abbreviations into the full standard names such as 'California' that the map service recognizes. Setting a data category (option A) only tells Power BI what kind of geographic data the field contains; it does not convert 'CA' into a recognizable state name, so the unmatched values would still fail to plot. Changing to a filled map (option D) or adding a custom map image (option C) alters the visualization type or background but does nothing to fix the underlying mismatched state values.

Answer

Use the 'Data category' property to set the field to 'State or Province'

Answer

Add a custom map image

Answer

Change the map visual to a filled map

Question 11

You have a Power BI report with a page that contains a bar chart showing sales by product category. You want to allow users to click on a bar and navigate to a different report page that shows detailed sales for that category. Which feature should you use?

Accepted Answer

Drillthrough. Drillthrough in Power BI allows users to right-click a data point (like a bar in a bar chart) and navigate to a separate report page filtered to that specific context, such as the selected product category. This is exactly the requirement: clicking a bar to see detailed sales for that category on another page. Drillthrough pages are configured with a field well that defines the filter context passed from the source visual.

Answer

Bookmarks

Answer

Report page tooltips

Answer

Cross-filtering

Question 12

You are optimizing a DAX query that returns product-country combinations with total sales over 10,000. The query runs slowly. What is the primary performance issue with this query?

Accepted Answer

Using SUMMARIZE instead of SUMMARIZECOLUMNS causes inefficient grouping and measure evaluation.. The primary issue is that the query uses SUMMARIZE to group product-country combinations and evaluate the [Total Sales] measure, which is inefficient because SUMMARIZE was not designed for measure evaluation and can produce incorrect or slow results in this pattern. SUMMARIZECOLUMNS is the optimized function for this scenario, as it is specifically engineered for grouping and evaluating measures efficiently in DAX queries. The other options do not fit: SUMX is not inherently slow and is often the correct iterator for row-by-row aggregation, FILTER is not the bottleneck here and CALCULATETABLE would not address the grouping inefficiency, and missing relationships would typically cause errors or blank results rather than merely slow performance.

Answer

The measure [Total Sales] is defined using SUMX which is slow.

Answer

The FILTER function should be replaced with CALCULATETABLE for better performance.

Answer

The query lacks proper relationships between tables, causing cross joins.

Question 13

You are a Power BI developer for a retail company. You have a semantic model that includes a 'Sales' fact table with columns: 'Date', 'ProductID', 'StoreID', 'Quantity', 'UnitPrice'. The 'Product' dimension table includes 'ProductID', 'ProductName', 'Category', 'SubCategory'. The 'Store' dimension table includes 'StoreID', 'StoreName', 'Region', 'District'. You need to create a report page that allows users to analyze sales performance by product category and store region. The report must include a matrix visual with: - Rows: Product Category - Columns: Store Region - Values: Total Sales Amount (Quantity * UnitPrice) Additionally, users must be able to drill down from category to subcategory in the rows, and from region to district in the columns. You also need to ensure that when a user selects a specific store region, the matrix only shows data for that region and its districts. You have created the measures and the matrix visual. However, when you test the drill down, the hierarchy does not work as expected: clicking the expand icon on a category does not show subcategories. What is the most likely cause?

Accepted Answer

The matrix rows do not have a hierarchy defined; Category and SubCategory are separate fields.. The correct answer is C: the matrix rows do not have a hierarchy defined, with Category and SubCategory as separate fields. In Power BI, drill-down in a matrix requires a single field well containing a hierarchy (or nested fields in the Rows bucket) so the expand/collapse icon can navigate from Category to SubCategory; placing Category and SubCategory as independent fields prevents the expected drill behavior. Option A is wrong because a blank Total Sales measure would show empty values, not block the hierarchy expansion. Option B is wrong because a Store Region slicer filters data but does not disable matrix drill-down. Option D is wrong because single-direction relationships affect filter propagation and drillthrough pages, not in-matrix hierarchy expansion.

Answer

The Total Sales measure is incorrectly defined, causing blank values for subcategories.

Answer

A slicer for Store Region is interfering with the matrix drill down behavior.

Answer

The relationship between Sales and Product is set to single direction, preventing drill through.

Question 14

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?

Accepted Answer

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

In the 'Edit interactions' settings, disable cross-filtering between the line chart and table.

Answer

Create a drillthrough page and configure the line chart to drill through to the table page.

Answer

Add a bookmark for each date and set the line chart to trigger the bookmark on click.

Question 15

You are a Power BI analyst for a financial services company. You have a semantic model that contains a 'Transactions' fact table with millions of rows, and a 'Calendar' date dimension table. You need to create a report page that shows the year-to-date (YTD) total transaction amount compared to the same period last year (SPLY). The report must allow users to select a year from a slicer, and the YTD calculation should always be based on the maximum date in the data for the selected year (i.e., show YTD as of the latest available date). You have created the following measures:

- Total Amount = SUM(Transactions[Amount])
- YTD Amount = TOTALYTD([Total Amount], 'Calendar'[Date])
- SPLY YTD = CALCULATE([YTD Amount], SAMEPERIODLASTYEAR('Calendar'[Date]))

When users select a year from the slicer, the YTD Amount does not correctly show the YTD as of the last date in the selected year; instead, it shows the YTD for each individual date in the context. What is the most likely issue?

Accepted Answer

The YTD measure should be wrapped in a CALCULATE that filters to the last date in the selected period.. The correct option is C: the YTD measure must be wrapped in a CALCULATE that filters the Calendar to the last date in the selected period, because TOTALYTD evaluates at whatever date granularity is in the current filter context, so on a visual by date it returns a running YTD per day rather than a single YTD-as-of-latest-date value. To force the measure to always show YTD as of the maximum date for the selected year, you need something like CALCULATE([YTD Amount], LASTDATE('Calendar'[Date])) (or FILTER to the max date), which overrides the row-level date context. Option A is wrong because an inactive relationship would break all time intelligence, not just the YTD granularity, and the scenario implies the Calendar relationship works. Option B is wrong because slicer-to-Calendar filtering is not the cause; the slicer already filters the year, and the issue is date-level context within the visual. Option D is wrong because DATESYTD is the underlying time-intelligence function TOTALYTD uses and would not by itself change the per-date evaluation behavior.

Answer

The relationship between Transactions and Calendar is not active.

Answer

The slicer is not configured to filter the Calendar table.

Answer

The TOTALYTD function is not appropriate; you should use DATESYTD instead.