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

Question 1

You have a Power BI report with a table visual that shows sales data by region and product. The table has columns Region, Product, SalesAmount, and Profit. Users report that the table is difficult to read because there are many rows and the numbers are not formatted consistently. You need to improve the readability of the table. (Choose two.)

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

Accepted Answer

Apply a consistent number format to the SalesAmount and Profit columns, such as currency with two decimal places.. Conditional formatting with data bars provides a visual representation of values, making comparisons faster, while consistent number formatting ensures values are displayed uniformly. Together, these two changes directly enhance table readability without altering the data or requiring user interaction.

Answer

Increase the font size of all columns to make the text more legible.

Answer

Sort the table by SalesAmount in descending order.

Answer

Add a slicer for Region and Product to allow users to filter the table.

Question 2

You have a Power BI report with a clustered bar chart that shows sales by product category. Users want to see the underlying data for a specific bar. What feature should you enable to allow users to view the details?

Accepted Answer

See data. The 'See data' feature is designed to let users view the data behind a visual. When a user selects a bar in a clustered bar chart, using 'See data' displays a table of the data that contributes to that bar, including the category and sales values. This provides the desired detail without needing to create a separate page or use complex DAX.

Answer

Drill through

Answer

See records

Answer

Q&A

Question 3

You have a Power BI report with a measure that calculates total sales. You want to display the total sales for the previous year alongside the current year in a matrix visual. Which DAX function should you use to retrieve the previous year's sales?

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR is specifically designed to return the same set of dates one year prior, making it ideal for year-over-year calculations. When used inside CALCULATE, it shifts the filter context to the previous year, allowing the measure to compute sales for that period. This function requires a marked date table to work correctly, ensuring accurate time intelligence.

Answer

DATEADD

Answer

PARALLELPERIOD

Answer

PREVIOUSYEAR

Question 4

You have a Power BI report with a scatter chart that shows sales versus profit by product. You want to enable users to analyze the data points more effectively. Which two actions should you perform? (Choose two.)

Accepted Answer

Add a play axis to animate the scatter chart over time.. To analyze data points in a scatter chart more effectively, adding a play axis enables animation over time, revealing trends and movements. Enabling cross-filtering allows users to select points and see how they affect other visuals, facilitating interactive exploration. These two actions provide dynamic and interactive analysis capabilities, whereas the other options are either cosmetic or inappropriate for scatter charts.

Answer

Increase the size of the data points to make them more visible.

Answer

Add a tooltip page that displays detailed information for each data point.

Answer

Set the scatter chart to use a categorical X-axis.

Question 5

You are a Power BI developer for a financial services company. You have a report page with a slicer for 'Account Type' and a card visual showing total transactions. Users report that when they select multiple account types in the slicer, the card shows the sum of transactions for all selected types, but they want to see the average transaction amount per account type. What should you do to achieve this?

Accepted Answer

Create a measure using AVERAGEX to calculate the average transaction amount per account type, and use it in a table visual instead of a card.. To show average transaction amount per account type when multiple types are selected, you need a measure that calculates the average for each type and a visual that can display multiple categories. A table visual with a measure using AVERAGEX over the Account Type table achieves this. A card visual only shows one value.

Answer

Add a second slicer for transaction amount and set it to 'Average'.

Answer

Change the card visual to use the 'Average' aggregation on the transaction amount field.

Answer

Use the 'Quick measure' feature to create an average per category measure and add it to the card visual.

Question 6

You are a data analyst for a retail company. You have a Power BI report with a bar chart showing sales by product category. Users want to analyze the data by selecting a category and seeing only that category's sales, while also being able to select multiple categories. You need to add a slicer that allows users to select one or more product categories. Which two actions should you perform? (Choose two.)

Accepted Answer

Add a slicer visual and place the ProductCategory field in the Field well.. To enable users to select one or more product categories, you add a slicer with the ProductCategory field. This creates a categorical slicer that supports multi-select by default. Additionally, you must ensure the slicer filters the bar chart, which may require checking or setting interactions. These two actions together provide the required filtering capability.

Answer

Set the slicer's Selection property to 'Multi-select with CTRL'.

Answer

Add a slicer visual and place the Sales measure in the Field well.

Answer

In the slicer's formatting options, enable the 'Multi-select' toggle.

Question 7

You are a Power BI data analyst for a financial services company. You have a report with a bar chart showing total transaction amount by month. The dataset includes a Date table marked as a date table and a measure 'Total Amount' that sums transaction amounts. You need to add a reference line to the chart that displays the average monthly transaction amount across all months in the current filter context. Which two actions should you perform? (Choose two.)

Accepted Answer

Create a measure that calculates the average monthly transaction amount using AVERAGEX over the Date table.. To show the average monthly transaction amount as a reference line, you need a DAX measure that computes the average across months in the filter context. Then, you add that measure as a constant line via the Analytics pane. The built-in average line would average the plotted values, which may differ from the true monthly average, and forecasting or trend lines do not serve this purpose.

Answer

Use the 'Forecast' feature in the Analytics pane to predict the average monthly amount.

Answer

In the Analytics pane, add an Average line and set its scope to 'Per visual'.

Answer

Add a trend line and set its type to 'Average'.

Question 8

You are a Power BI data analyst for a financial services company. You have a report with a scatter chart that plots revenue (X-axis) versus profit (Y-axis) for each sales representative. You need to ensure that when a user selects a sales representative in a slicer, only that representative's data point is highlighted, while all other points remain visible but dimmed. What should you do?

Accepted Answer

Set the interaction between the slicer and the scatter chart to 'Highlight'.. Power BI allows you to control how visuals interact. By default, a slicer filters other visuals, removing non-matching data. Changing the interaction to 'Highlight' instead of 'Filter' makes the scatter chart highlight the selected representative's point while dimming others. This is done via the 'Edit interactions' feature, accessible from the Format ribbon.

Answer

Enable cross-highlighting between the slicer and the scatter chart.

Answer

Add a measure that uses the SELECTEDVALUE function to conditionally format the data points.

Answer

Use a bookmarks navigator to switch between filtered and unfiltered views.

Question 9

You are a data analyst for a manufacturing company. You have a Power BI report with a matrix visual showing production volumes by plant and product line. Users need to be able to expand and collapse individual plant rows to see product line details. However, the matrix currently shows all product lines expanded by default, making it cluttered. What should you configure to allow users to control the expansion?

Accepted Answer

Ensure the matrix uses a hierarchy for rows and set the 'Expand/collapse' option to 'On' in the row headers section.. The matrix visual supports expand/collapse when a hierarchy is placed on rows. By enabling the 'Expand/collapse' option in the row headers formatting, users can interactively expand or collapse groups. This gives them control over the detail level and reduces visual clutter.

Answer

Set the matrix visual's 'Row headers' to 'Stepped layout'.

Answer

In the matrix visual's formatting options, turn on 'Row headers' and enable 'Stepped layout' with 'Expand/collapse'.

Answer

Enable 'Drill down' on the matrix and set the default drill state to collapsed.

Question 10

You are building a Power BI report for a financial analyst. The report includes a card visual that shows total revenue. The analyst wants to see the revenue for the previous month when they hover over the card. You need to implement this without adding another visual to the page. What should you do?

Accepted Answer

Add a tooltip page and configure the card visual to use it as a report page tooltip.. To show additional information on hover without adding a visual, you create a report page tooltip. This page can contain any visuals, including a card showing previous month revenue. Then, you set the card visual's tooltip to that page. This provides the desired hover experience while keeping the main page clean.

Answer

Create a measure for previous month revenue and add it to the card's Tooltips field well.

Answer

Use the 'Q&A' visual to ask for previous month revenue when hovering over the card.

Answer

In the card's formatting options, enable the 'Tooltip' toggle and enter a DAX expression for the previous month revenue.

Question 11

You are a Power BI data analyst for a software company. You have a report with a table visual that lists support tickets. The table includes columns: TicketID, Priority, Status, and AssignedTo. You need to apply conditional formatting to the Status column so that 'Open' tickets appear with a red background, 'In Progress' with yellow, and 'Closed' with green. You also want the formatting to be based on the text value, not a measure. What should you do?

Accepted Answer

Use the 'Background color' option in conditional formatting, select 'Format by' as 'Field value', and choose the Status field itself with a color scale.. To apply conditional formatting based on text values, you use the 'Field value' option and select the text column. Power BI then allows you to assign colors to each distinct value. The Rules option does not support text conditions, and using a measure adds unnecessary complexity. This method is straightforward and meets the requirement of basing formatting on the Status text.

Answer

Use the 'Background color' option in conditional formatting, select 'Format by' as 'Rules', and define rules based on the Status field using the 'is' operator.

Answer

Use the 'Background color' option in conditional formatting, select 'Format by' as 'Field value', and choose a measure that returns a color based on the Status.

Answer

Use the 'Background color' option in conditional formatting, select 'Format by' as 'Rules', and define rules based on the Status field.

Question 12

A company wants to create a Power BI report that shows sales performance by region. The data contains a table 'Sales' with columns: Date, Amount, RegionID, and ProductID. They also have a 'Regions' table with RegionID and RegionName. They want to display a matrix visual with RegionName on rows and Year on columns, with the sum of Amount as values. However, the report displays only 'RegionID' instead of 'RegionName'. What is the most likely cause?

Accepted Answer

There is no active relationship between the Sales and Regions tables.. If there is no active relationship between the Sales and Regions tables, Power BI cannot use the RegionName from the Regions table to filter or group the Sales data. Instead, it defaults to displaying the RegionID from the Sales table, which is the only related field available in the visual. An active relationship must exist between the two tables on the RegionID columns for RegionName to appear in the matrix.

Answer

The relationship is configured as many-to-many.

Answer

The relationship direction is set to Both.

Answer

The RegionID column in the Sales table is hidden.

Question 13

A Power BI report includes a bar chart showing total sales by product category. The report designer wants to add a trend line to the chart to show the overall sales trend over time. Which type of visual should be used instead?

Accepted Answer

Line chart. A line chart is the correct visual to show a trend over time because it plots data points connected by straight lines, making it easy to see the overall direction and pattern of total sales across a continuous time axis. Bar charts, including stacked variants, are designed for comparing discrete categories, not for displaying continuous trends.

Answer

Stacked bar chart

Answer

Scatter chart

Answer

Pie chart

Question 14

A Power BI report contains a table visual that displays employee names and their total sales. The data model includes an Employee table with columns: EmployeeID, Name, Department, and HireDate. The Sales table has columns: SaleID, EmployeeID, Amount, and SaleDate. The relationship between Employee and Sales is one-to-many. The user wants to see only employees who have made at least one sale. However, the table shows all employees, including those with no sales (blank Amount). What is the most likely reason?

Accepted Answer

There is no visual-level filter to exclude blank values.. The table visual is showing all employees due to the absence of a visual-level filter to exclude blank or zero sales amounts. In Power BI, a one-to-many relationship between Employee and Sales means that employees without sales will still appear in the visual unless explicitly filtered out, as the relationship does not automatically suppress rows from the 'one' side when there are no matching rows on the 'many' side.

Answer

The EmployeeID column in the Employee table is hidden.

Answer

The relationship is many-to-one, not one-to-many.

Answer

The relationship direction is set to Single from Employee to Sales.

Question 15

A data analyst creates a Power BI report that uses a date table with a continuous date range. They want to calculate the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX expression should they use?

Accepted Answer

CALCULATE(SUM(Sales[Amount]), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -12, MONTH)). DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -12, MONTH) returns a contiguous set of dates from 12 months before the last date in the current filter context up to that last date, providing an exact 12-month window. This function handles month boundaries correctly and is the standard way to calculate rolling 12-month totals in DAX. Option A uses 365 days, which can be imprecise due to leap years.

Answer

CALCULATE(SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], MAX('Date'[Date]) - 365, MAX('Date'[Date])))

Answer

TOTALMTD(SUM(Sales[Amount]), 'Date'[Date])

Answer

CALCULATE(SUM(Sales[Amount]), DATESYTD('Date'[Date]))