Given a Matrix visual with Category in Rows and Year in Columns, what will be shown if you add Sales to Values?

medium📝 Formula Result Q13 of 15

Power BI - Basic Visualizations

Given a Matrix visual with Category in Rows and Year in Columns, what will be shown if you add Sales to Values?

AA list of all sales transactions without grouping.

BSales totals only by Category without Year breakdown.

CSales totals only by Year without Category grouping.

DSales totals grouped by Category and Year with subtotals.

Step-by-Step Solution

Solution:

Step 1: Understand Matrix grouping by Rows and Columns
Category in Rows groups data vertically; Year in Columns groups data horizontally.
Step 2: Adding Sales to Values
Sales values will be aggregated for each Category-Year combination, showing subtotals.
Final Answer:
Sales totals grouped by Category and Year with subtotals. -> Option D
Quick Check:
Matrix with Rows + Columns = grouped totals [OK]

Quick Trick: Rows + Columns + Values = grouped totals with subtotals [OK]

Common Mistakes:

Master "Basic Visualizations" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes