New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Microsoft Certified: Power BI Data Analyst Associate PL-300 Dumps PDF

Page: 11 / 15
Total 386 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 41

You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.

The solution must use the existing calculations only.

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

NOTE: Each correct selection is worth one point.

Options:

Question 42

ESTION NO: 322

You have a Power BI data model that contains a table named Employees. The table has the following columns:

• Employee Name

• Email Address

• Start Date

• Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

• Users must see only their own employee data

• The DAX expression must work in both Power 81 Desktop and the Power BI service.

Which expression should you use?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 43

UESTION NO: 7

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by

customer segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

Options:

A.

no impact

B.

highlight

C.

filter

Question 44

Each employee has one manager as shown in the ParentEmployeelD column,

All reporting paths lead to the CEO at the top of the organizational hierarchy.

You need to create a calculated column that returns the count of levels from each employee to the CEO.

Which DAX expression should you use?

Options:

A.

Option A

B.

Option B

C.

option C

D.

Option D

Page: 11 / 15
Total 386 questions