Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

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
[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 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Datapassion
Highly Voted 8 months, 3 weeks 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 20 times
JudT
7 months, 3 weeks ago
Done! Thank you very much
upvoted 2 times
...
maymia87
8 months ago
Here's a tutorial https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/
upvoted 5 times
...
...
jaume
Most Recent 1 day, 10 hours ago
Selected Answer: C
Values in a matrix visual
upvoted 1 times
...
539d541
2 months, 3 weeks 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
3 months ago
Selected Answer: C
It seems to be a matrix, we need to put the measures in the values
upvoted 1 times
...
MITZ619
8 months, 1 week ago
Selected Answer: C
c. Value
upvoted 2 times
...
syjang_0421
8 months, 3 weeks ago
Selected Answer: C
Values
upvoted 3 times
...
Dani_eL
8 months, 3 weeks 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
7 months, 1 week ago
Make sure you got a matrix type of visual. It looks like you had just a table.
upvoted 6 times
...
...
Florinuca
8 months, 3 weeks 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
8 months, 3 weeks 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
8 months, 3 weeks 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
8 months, 3 weeks ago
C. Values
upvoted 3 times
...
JustdoBI
8 months, 3 weeks ago
Values
upvoted 3 times
...
6f38739
8 months, 3 weeks 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
Loading ...