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

Question 1

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. Option A is correct because you can create a calculated column that converts abbreviations to full names using a SWITCH or a mapping table. Option B is wrong because a filled map has the same recognition issue. Option C is wrong because setting data category does not change the values. Option D is wrong because custom map images require additional setup and may not solve the recognition issue.

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 2

You have a Power BI dataset that includes a table 'Orders' with columns: OrderDate, CustomerID, ProductID, Quantity, and Revenue. You need to create a measure that calculates the running total of Revenue over the last 12 months, but only for products that have been sold in the current month. The measure should be used in a line chart showing monthly revenue. You have the following options: A. Use the TOTALQTD function with a filter for last 12 months. B. Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. C. Create a calculated column for running total and then sum it. D. Use the WINDOW function (Preview). Which option should you choose?

Accepted Answer

Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. Option B is correct because you can use CALCULATE with DATESINPERIOD to compute the running total over 12 months, and add a filter to restrict to products that have sales in the current month. Option A is wrong because TOTALQTD is for quarter-to-date, not rolling 12 months. Option C is wrong because calculated columns are static and not dynamic for each month. Option D is wrong because WINDOW function is still in preview and not recommended for production.

Answer

Use the WINDOW function (Preview)

Answer

Use TOTALQTD with a filter for last 12 months

Answer

Create a calculated column for running total and then sum it

Question 3

You are a Power BI administrator for a large enterprise. You have a shared dataset that is used by multiple reports. The dataset contains sensitive financial data. You need to implement row-level security (RLS) so that managers can only see data for their own region. The dataset has a table 'Sales' with RegionID, and a table 'Managers' with ManagerID, ManagerName, and RegionID. You need to create an RLS role that filters the Sales table based on the logged-in user's region. You have the following options: A. Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'. B. Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. C. Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'. D. Create a role with a static filter for each region. Which option should you choose?

Accepted Answer

Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. Option B is correct because it uses LOOKUPVALUE to find the region for the logged-in user (ManagerName) from the Managers table, and then filters Sales accordingly. Option A is wrong because RegionID is not a user principal name. Option C is wrong because USERNAME() returns the user's login name, not region. Option D is wrong because static filters would require multiple roles and manual maintenance.

Answer

Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'

Answer

Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'

Answer

Create a role with a static filter for each region

Question 4

You have a Power BI report that uses a date table with a continuous date range. You want to add a slicer that allows users to select a single month and then display data for that month only. You add a slicer visual with the Date field. However, the slicer shows individual dates instead of months. How should you configure the slicer to show months? A. Change the slicer type to 'Between' and then select a month range. B. Create a calculated column for Month and use that in the slicer. C. Use the 'Hierarchy' slicer with Date hierarchy. D. Set the slicer to 'List' and enable 'Show select all'. Which option is best?

Accepted Answer

Create a calculated column for Month and use that in the slicer. Option B is correct because creating a Month column (e.g., 'Month Year') allows users to select a month. Option A is wrong because 'Between' slicer still shows dates. Option C is wrong because hierarchy slicer shows drill-down, not single selection. Option D is wrong because 'Select all' does not group by month.

Answer

Set the slicer to 'List' and enable 'Show select all'

Answer

Use the 'Hierarchy' slicer with Date hierarchy

Answer

Change the slicer type to 'Between' and then select a month range

Question 5

You have a Power BI report that displays key performance indicators (KPIs) using a KPI visual. The visual shows a measure 'Current Sales' with a goal of 'Target Sales'. You want to show the status (on track, behind, etc.) based on the difference. You configure the KPI visual with the measure, goal, and trend axis. However, the status indicator does not appear. What should you do? A. Ensure the measure and goal are both numeric and have the same unit. B. Add a trend line to the visual. C. Set the 'Direction' property to 'High is good' or 'Low is good'. D. Use a different visual like a gauge. Which option is the best?

Accepted Answer

Set the 'Direction' property to 'High is good' or 'Low is good'. Option C is correct because the KPI visual requires setting the direction to calculate status. Option A is wrong because units don't need to be same. Option B is wrong because trend line is optional. Option D is wrong because gauge is an alternative but not a fix for KPI.

Answer

Add a trend line to the visual

Answer

Ensure the measure and goal are both numeric and have the same unit

Answer

Use a different visual like a gauge

Question 6

You are building a Power BI report to analyze sales performance. You need to allow users to dynamically switch between different measures (e.g., Sales Amount, Sales Quantity, Profit Margin) using a single slicer. Which two features should you implement?

Accepted Answer

Create a disconnected parameter table with measure names.. The correct combination is using a disconnected parameter table and field parameters. A disconnected parameter table allows switching measures via a slicer, and field parameters (introduced in Power BI Desktop) dynamically change the field used in visuals. A calculation group also works, but the question asks for two features; field parameters and disconnected tables are the standard approach. Option C (calculated table) is not directly for switching measures; Option D (report page tooltip) is unrelated.

Answer

Implement a calculation group to switch measures.

Answer

Use a report page tooltip to display measure choices.

Answer

Create a calculated table to hold measure values.

Question 7

You are designing a Power BI report for the executive team. The report must meet the following requirements:
- The report must be accessible to users with visual impairments.
- Visuals must automatically adjust to display the most important data when viewed on mobile devices.
- Users must be able to drill through from a summary page to a detail page by clicking on a data point.
Which three features should you implement?

Accepted Answer

Enable 'Use high contrast colors' in the report theme.. Correct: A (enable automatic page refresh ensures real-time data, but actually for accessibility, using high contrast and screen readers is key; however, automatic page refresh is not for accessibility. Wait, the correct answers are B, D, E. Actually, for accessibility, enable 'Use high contrast colors' helps. For mobile responsiveness, 'Responsive visuals' is correct. For drill through, 'Create a drillthrough page' is correct. Option A (automatic page refresh) is not required for these requirements. Option C (bookmarks) is for navigation, not drill through.

Answer

Enable automatic page refresh for real-time data.

Answer

Use bookmarks to create a drillthrough experience.

Question 8

You are creating a Power BI report to analyze customer feedback. You need to display the distribution of feedback ratings (1-5 stars) and also show the trend of average rating over time. Which two visual types should you use?

Accepted Answer

Column chart. A histogram is not a standard Power BI visual; a column chart can show distribution. For trend, a line chart is appropriate. So correct: B and D. Option A (histogram) is not a native visual; Option C (pie chart) shows proportion but not distribution; Option E (scatter chart) is for relationships.

Answer

Pie chart

Answer

Histogram

Answer

Scatter chart

Question 9

You run the above DAX query in DAX Studio. The result shows profit margin values for each year, but all values are the same for every year despite sales amounts varying. What is the most likely cause?

Accepted Answer

The measures use row context instead of filter context, causing them to evaluate over the entire table.. The issue is that the measures [Total Sales] and [Total Cost] are defined using SUMX over the entire Sales table without any filter context propagation from SUMMARIZECOLUMNS. The SUMMARIZECOLUMNS function only provides row context for the columns in the group by, but measures that use SUMX with a row iterator (Sales table) are not automatically filtered by the year. To get year-level profit margin, the measures should be written using CALCULATE with appropriate filters, or the SUMX should be replaced with SUM after filtering. Option C is correct because the measures are not respecting the filter context. Option A is incorrect because there is no calculated column. Option B is incorrect because row context is not an issue; it's filter context. Option D is incorrect because error handling is not the cause.

Answer

The Sales table contains a calculated column that overrides the year filter.

Answer

The DIVIDE function is not handling division by zero correctly.

Answer

The SUMMARIZECOLUMNS function is not compatible with measures that use SUMX.

Question 10

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 is the correct feature for navigating from a summary visual to a detail page for a specific data point. Cross-filtering only filters other visuals on the same page. Bookmarks are for saved views. Report page tooltips are for hover details. Custom visuals are not needed.

Answer

Bookmarks

Answer

Report page tooltips

Answer

Cross-filtering

Question 11

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 query uses SUMMARIZE which can be inefficient for grouping because it performs a table scan and then adds a measure. The better approach is to use SUMMARIZECOLUMNS which is optimized for this scenario. Also, adding columns after grouping can be slower. Option A is correct. Option B is incorrect because FILTER is not the main issue; it's the grouping. Option C is incorrect because Products and Customers dimensions are typically not the cause. Option D is incorrect because the measure itself might be fine.

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 12

You are designing a Power BI report for a sales team. The team needs to see the top 10 products by sales amount, but also want to see the sales amount for all other products aggregated as 'Others'. What is the best approach to create this visual?

Accepted Answer

Create a calculated column that categorizes products as 'Top 10' or 'Others' based on rank, then use that column in the visual.. The best approach is to create a measure that ranks products and then use TOPN to get top 10, and a separate measure for others. Alternatively, use a grouping in the data model. Option B is the most straightforward: create a calculated column to group top 10 and others. Option A is incorrect because Top N filter does not aggregate others. Option C is incorrect because RANKX alone doesn't group others. Option D is incorrect because a calculated table would be disconnected.

Answer

Use a Top N filter on the visual to show top 10 and enable the 'Others' option in the filter pane.

Answer

Create a calculated table that holds the top 10 products and join it to the main table.

Answer

Use the RANKX function in a measure and filter the visual to show rank <= 10.

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.. For drill down to work in a matrix, the fields must be in a hierarchy. The correct approach is to use a hierarchy in the rows and columns. If the fields are simply placed as separate rows/columns, drill down won't work. Option A is correct because without a hierarchy, the expand button will not drill down. Option B is incorrect because the measure is defined correctly. Option C is incorrect because cross-filter direction doesn't affect drill down. Option D is incorrect because slicer interaction is not the issue.

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 issue is likely that cross-filtering between the line chart and table is disabled. By default, visuals cross-filter each other, but if it's turned off, clicking won't affect others. Option A is correct: enable the cross-filter interaction. Option B is incorrect because drillthrough is for page navigation. Option C is incorrect because bookmarks are not needed. Option D is incorrect because editing interactions is the correct approach but the specific action is to enable cross-filtering, not disable.

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 TOTALYTD function calculates YTD for each date in the filter context. If the visual has a date field, it will show YTD for each date. To show a single YTD value as of the last date, you need to use a measure that filters to the last date. Option D is correct: you need to modify the measure to use LASTDATE or MAX to get the YTD as of the last date. Option A is incorrect because TOTALYTD is correct syntax. Option B is incorrect because the relationship is fine. Option C is incorrect because the issue is not with slicer interaction.

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.