Bird
0
0

You created a Matrix visual but subtotals are not showing. What is the most likely reason?

medium📝 Formula Fix Q14 of 15
Power BI - Basic Visualizations
You created a Matrix visual but subtotals are not showing. What is the most likely reason?
ASubtotals are disabled in the Matrix visual settings.
BYou did not add any fields to the Values area.
CThe data source has no numeric columns.
DMatrix visuals never show subtotals.
Step-by-Step Solution
Solution:
  1. Step 1: Check Matrix visual subtotal settings

    Subtotals can be turned on or off in the Format pane under Subtotals.
  2. Step 2: Confirm fields and data type

    Even with fields added, subtotals won't show if disabled in settings.
  3. Final Answer:

    Subtotals are disabled in the Matrix visual settings. -> Option A
  4. Quick Check:

    Subtotals off in settings = no subtotals shown [OK]
Quick Trick: Check subtotal toggle in Format pane if subtotals missing [OK]
Common Mistakes:
  • Assuming subtotals show automatically without enabling
  • Thinking numeric data is required for subtotals
  • Believing matrices never show subtotals

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes