Microsoft PL-300 Practice Test - Questions Answers, Page 34

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

You have a Power B1 report. The report contains a line chart that displays sales data for several regions.

You need to add an element to the report that will enable users to filter the sales data to include only a selected region.

Which two elements achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

DRAG DROP

You plan to use Power BI to create a quarterly profit report that meets the following requirements:

* Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage

* Compares profit margins across sales regions

Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Power B1 report that contains the table visual shown in the following exhibit.

You need to modify the visual to display as shown in the following exhibit.

How should you configure the visual? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Power B1 report that contains the fields shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.

You need to transform the data to meet the following requirements:

* The first column must contain the month.

* The second column must contain the year.

* The third column must contain the order amount for the month and year.

Which transformation should you use first?

You have a Power B1 dataset that contains quarterly sales performance data.

You need to enable managers to review the data in a format that meets the following requirements:

* Is optimized for printing.

* Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

A user creates a Power B1 report named ReportA that uses a custom theme

You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

* Sales invoices must be exported in a PDF format

* The PDF exports must show all columns and rows clearly.

What should you create?