When using Copilot to create a new report page, what does the analyst need to provide?

A natural language prompt describing the desired content

You have a table visual with monthly sales data. You want to add a column that shows the difference between each month's sales and the previous month's sales, without creating a new measure in the data model. What should you use?

A visual calculation using DAX, such as 'Sales - PREVIOUS_MONTH(Sales)'.

A measure using DAX, such as 'CALCULATE(SUM(Sales), PREVIOUSMONTH(Date))'.

A quick measure for month-over-month change.

A calculated column in the data model using DAX.

You have a table visual showing sales by salesperson. You want to highlight the top 10 salespeople by revenue, but you also need to allow users to filter by region using a slicer. The highlighting should update dynamically based on the slicer selection. What should you do?

Use the 'Top N' filter on the table visual to show only the top 10 salespeople.

Apply conditional formatting based on the revenue value, using a color scale.

Create a bookmark for each region that applies a different conditional formatting rule.

Use conditional formatting with a rule that references a measure for the top 10 rank, and ensure the measure respects the slicer context.

Microsoft Certified:Power BI Data Analyst Associate

Domain 3Objective 1

Create Reports PL-300 Practice Questions (Page 7)

Part of the Visualize and analyze the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

11concepts

25–30%of the exam

Questions 31–35

31foundation · easy
Which DAX function is commonly used in visual calculations to compute a running total?
Select an answer first
32foundation · easy
To improve the user experience, a report author wants to hide a report page from the navigation tabs. Which setting should be used?
Select an answer first
33foundation · easy
When using Copilot to create a new report page, what does the analyst need to provide?
Select an answer first
34application · medium
You have a table visual with monthly sales data. You want to add a column that shows the difference between each month's sales and the previous month's sales, without creating a new measure in the data model. What should you use?
Select an answer first
35expert · hard
You have a table visual showing sales by salesperson. You want to highlight the top 10 salespeople by revenue, but you also need to allow users to filter by region using a slicer. The highlighting should update dynamically based on the slicer selection. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.

Create Reports PL-300 Practice Questions (Page 7)

Questions 31–35

Which DAX function is commonly used in visual calculations to compute a running total?

To improve the user experience, a report author wants to hide a report page from the navigation tabs. Which setting should be used?

When using Copilot to create a new report page, what does the analyst need to provide?

You have a table visual with monthly sales data. You want to add a column that shows the difference between each month's sales and the previous month's sales, without creating a new measure in the data model. What should you use?

You have a table visual showing sales by salesperson. You want to highlight the top 10 salespeople by revenue, but you also need to allow users to filter by region using a slicer. The highlighting should update dynamically based on the slicer selection. What should you do?

Keep studying — Visualize and analyze the data