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

PL-300 By islever Editorial Last updated

Create reports

Short answer

C Measures belong in the Values well; the exhibit's row-like look comes from the switch-values-to-rows format option.

Question

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? - Exhibit: Placing measures in the Values well to build the required matrix
  1. Columns
  2. Rows
  3. Values Correct Answer
  4. Drill through

Key Takeaways

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.

Common mistake: 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.

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

This link opens the official vendor documentation in a new tab.

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.

Discussion 12 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 12

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

Reader comments & corrections

No reader corrections 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.

PREVIOUSYEAR returns the full previous year, not the same day of last year

S-grade

Shrinking a Power BI model for monthly transaction totals with a star schema

S-grade

Northwind Traders semantic model: choosing Import storage mode for the Power BI tables

S-grade

Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector

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