CertsTopics Logo

Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

All PL-300 Test Inside Microsoft Questions

Page: 7 / 9
Total 342 questions
Get PL-300 Full Access Download PL-300 PDF

Microsoft Power BI Data Analyst Questions and Answers

Question 25

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options:

A.

Add the same slicer to each page and configure Sync slicers.

B.

Edit the interactions of the KPI visualization.

C.

Configure a page-level filter.

D.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

E.

Configure a report-level filter.

Question 26

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.

Options:

Question 27

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Options:

A.

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

B.

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

C.

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

D.

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

Question 28

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

Options:

A.

FORMAT('Date'[date], "MMM YYYY")

B.

FORMAT('Date' [date], "M YY")

C.

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D.

FORMAT('Date' [date_id], "MMM YYYY")

Page: 7 / 9
Total 342 questions
Get PL-300 Full Access Download PL-300 PDF