Learn how to configure a Power BI table visual to display a specific format by setting the appropriate options for subtotals, stepped layout, and switching values to rows. Prepare for the PL-300 certification exam with this detailed explanation and example.
Table of Contents
Question
You have a Power BI report that contains the table visual shown in the following exhibit.
You need to modify the visual to display as shown in the following exhibit.
How should you configure the visual? To answer, select the appropriate options in the answer area.
Type:
- Matrix
- Multi-row card
- Table
Format:
- Set Rows subtotals to Off.
- Set Stepped layout to Off.
- Set Switch values to rows to On.
Answer
Type: Matrix
Format: Set Switch values to rows to On.
Explanation
To modify the table visual to display as shown in the second exhibit, you should configure the visual as follows:
Type: Table
The visual should be a standard table, not a matrix or multi-row card.
Format:
– Set Rows subtotals to Off.
This will remove any subtotals that may be displayed for the rows.
– Set Stepped layout to Off.
Turning off stepped layout will put each column on the same line instead of staggering them.
– Set Switch values to rows to On.
This option will pivot the table so that the unique column values (the dates) become row headers, and the metrics (Total Sales and Total Cost) become column headers.
So in summary, configuring the visual as a standard Table, turning off row subtotals and stepped layout, and switching the column values to rows, will transform the visual from the format in the first exhibit to match the formatting shown in the second exhibit.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.