ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 83 discussion

Actual exam question from Microsoft's PL-300
Question #: 81
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer: C 🗳️
by 6f38739 at Feb. 28, 2024, 2:27 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Datapassion
Highly Voted 1 year, 2 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 23 times
JudT
1 year, 1 month ago
Done! Thank you very much
upvoted 2 times
...
maymia87
1 year, 1 month 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 5 months ago
Selected Answer: C
Calculated values will provide the summary values in a matrix table
upvoted 1 times
...
jaume
5 months, 2 weeks ago
Selected Answer: C
Values in a matrix visual
upvoted 1 times
...
539d541
8 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
8 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, 1 month ago
Selected Answer: C
c. Value
upvoted 2 times
...
syjang_0421
1 year, 2 months ago
Selected Answer: C
Values
upvoted 3 times
...
Dani_eL
1 year, 2 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 ago
Make sure you got a matrix type of visual. It looks like you had just a table.
upvoted 6 times
...
...
Florinuca
1 year, 2 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, 2 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
Datapassion
1 year, 2 months ago
Answer C is correct, to produce the same visual you need to turn ON "switch values to rows" in the format pane of your matrix
upvoted 2 times
...
...
Margaft
1 year, 2 months ago
C. Values
upvoted 4 times
...
JustdoBI
1 year, 2 months ago
Values
upvoted 3 times
...
6f38739
1 year, 2 months ago
Should be Values
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago