Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 83 discussion

Actual exam question from Microsoft's PL-300

Question #: 81
Topic #: 2

You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount.

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

In which section of the Fields well should you place the measures?

A. Columns
B. Rows
C. Values
D. Drill through

Show Suggested Answer

Suggested Answer: C 🗳️

by 6f38739 at Feb. 28, 2024, 2:27 p.m.

Comments

Submit Cancel

Datapassion

Highly Voted 1 year, 5 months ago

Correct answer is C To have the same exact matrix, you need to put the different measures in the "Values" well and then to go to the format pane of your matrix and select "Switch values to rows" under the "Values" section.

upvoted 24 times

JudT

1 year, 4 months ago

Done! Thank you very much

upvoted 2 times

...

maymia87

1 year, 4 months ago

Here's a tutorial https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/

upvoted 9 times

...

desibaby09

Most Recent 8 months ago

Selected Answer: C

Calculated values will provide the summary values in a matrix table

upvoted 1 times

...

jaume

8 months, 2 weeks ago

Selected Answer: C

Values in a matrix visual

upvoted 1 times

...

539d541

11 months, 1 week ago

Selected Answer: C

C is correct. Put measures in Values then switch values to rows in the formatting of the matrix

upvoted 2 times

...

rcaliandro

11 months, 2 weeks ago

Selected Answer: C

It seems to be a matrix, we need to put the measures in the values

upvoted 1 times

...

MITZ619

1 year, 4 months ago

Selected Answer: C

c. Value

upvoted 2 times

...

syjang_0421

1 year, 5 months ago

Selected Answer: C

Values

upvoted 3 times

...

Dani_eL

1 year, 5 months ago

none of the solutions work in a PBI desktop report. You can put ONE measure into values but as soon as you put the second one it becomes a second row header with corresponding values

upvoted 1 times

Piotrek_PL

1 year, 3 months ago

Make sure you got a matrix type of visual. It looks like you had just a table.

upvoted 6 times

...

Florinuca

1 year, 5 months ago

The correct answer is C - Values. Firstly, this type of visualization is a MATRIX. If you do a simple test in PowerBI Desktop, you can see that in the "Rows" section, we can't add measures! Most likely, the names of the measures in the rows of the matrix appear because the measures were put in "fields parameteres" that generated a Calculated Table, and the actual values of the measures appear by adding the measures (not from the Calculated Table) in the "Values" section.

upvoted 4 times

...

INDEAVR

1 year, 5 months ago

It is not possible to put a measure in Columns. You can only put a measure in Values. However, putting the measures in Values is not going to produce the same visual. Neither of the answers is correct in my opinion.

upvoted 3 times