Bird
0
0

How can you show subtotals for Product Categories in a Matrix visual but hide subtotals for Regions?

hard📝 Scenario Q9 of 15
Power BI - Basic Visualizations
How can you show subtotals for Product Categories in a Matrix visual but hide subtotals for Regions?
ARemove Region from Rows and add it to Filters
BUse a DAX measure to calculate subtotals manually
CTurn on subtotals for Product Category and turn off for Region in the Format pane
DSubtotals cannot be controlled separately for different row fields
Step-by-Step Solution
Solution:

  1. Step 1: Access Format pane subtotal settings

    Matrix visual allows enabling/disabling subtotals per row field.

  2. Step 2: Configure subtotals

    Turn on subtotals for Product Category and off for Region as needed.

  3. Final Answer:

    Turn on subtotals for Product Category and turn off for Region in the Format pane -> Option C

  4. Quick Check:

    Subtotals controlled per row field in Format pane [OK]
Quick Trick: Format pane controls subtotals per row field [OK]
Common Mistakes:
  • Thinking subtotals apply to all rows only
  • Trying to remove fields instead of formatting
  • Assuming manual DAX needed

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Map visualizations - Quiz 1easy Basic Visualizations - Why choosing the right visual matters - Quiz 10hard Basic Visualizations - Why choosing the right visual matters - Quiz 13medium Data Cleaning with Power Query - Removing duplicates - Quiz 10hard Data Cleaning with Power Query - Header promotion - Quiz 4medium Data Cleaning with Power Query - Pivoting columns - Quiz 15hard Getting Data - Multiple data sources in one report - Quiz 11easy Power Query Editor - Replace values - Quiz 8hard Power Query Editor - Replace values - Quiz 4medium Power Query Editor - Data type changes - Quiz 6medium