Placing measures in the Values well to build the required matrix visual

Create reports
Answer Correct answer: C — measures belong in the Values well; the exhibit's row-like look comes from the switch-values-to-rows format option.

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? - image

  1. Columns
  2. Rows
  3. Values Correct Answer
  4. Drill through
matrix values well switch values to rows power bi measures

Community Votes

C
100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Measures always go into the Values well of a matrix — any row-like arrangement of measures (as the exhibit shows) is achieved afterwards with the matrix format option 'switch values to rows', not by dropping measures into Rows.

A matrix visual displaying Order Quantity, Product Cost, and Sales Amount must be assembled from three Sales measures, so the Fields well section that receives measures has to be identified.

Putting measures into Rows because they appear down the side of the exhibit — Rows is reserved for field columns that define grouping levels, and the sideways look comes from a formatting toggle applied later.

Community Discussion (13 comments)

Datapassion 👍 23
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.
desibaby09 👍 1 Selected: C
Calculated values will provide the summary values in a matrix table
jaume 👍 1 Selected: C
Values in a matrix visual
539d541 👍 2 Selected: C
C is correct. Put measures in Values then switch values to rows in the formatting of the matrix
rcaliandro 👍 1 Selected: C
It seems to be a matrix, we need to put the measures in the values
MITZ619 👍 2 Selected: C
c. Value
syjang_0421 👍 3 Selected: C
Values
Dani_eL 👍 1
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
Florinuca 👍 4
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.
INDEAVR 👍 3
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.
Margaft 👍 4
C. Values
JustdoBI 👍 3
Values
6f38739 👍 3
Should be Values

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Matrix visuals aggregate data, and only fields or measures placed in the Values well are aggregated and displayed as the matrix body. The exhibit's layout — measure names listed vertically with their values beside them — is the standard matrix configuration of measures in Values combined with the 'switch values to rows' setting in the visual's format pane. The Fields well answer is therefore Values (C).

Why the Other Options Are Wrong

Columns (A) and Rows (B) hold field columns that define the matrix's grouping hierarchy; measures placed there would attempt to group by each measure's value rather than summarize, which is not valid for building this visual. Drill through (D) is a well for fields that enable drillthrough navigation from the visual — again unrelated to how measures render.

Community Comment Notes

The most-endorsed comment spells out the full recipe: measures go in the Values well, then 'switch values to rows' under the matrix format options reproduces the exhibit exactly. Several other commenters independently answer Values with the same reasoning.

Official Reference

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Related Analysis

You are reviewing a Power BI data model. You have a calculat

A-Grade

You have a Power BI report that contains a card. The card di

A-Grade

You have a Microsoft 365 subscription that contains the reso

S-Grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide