Tables & detailNative Power BIRecommendedLive example
Matrix
Display hierarchical and multidimensional data with expand/collapse, subtotals and drill.
Department → product group → product
Hierarchy: department › productGroup › productExpanded level 1 of 3
| Rows | Revenue | Budget | vs Budget |
|---|---|---|---|
| €2.4M | €2.5M | -0.9% | |
| €1.7M | €1.7M | -0.7% | |
| €1.7M | €1.7M | -0.8% | |
| €1.4M | €1.4M | -1.4% | |
| €1.2M | €1.2M | -1.7% | |
| Total | €8.4M | €8.5M | -1.0% |
Simulated behaviour on the shared fictional retail dataset. Native mechanism: Yes.
Best for
BAF → product group → article, hierarchical operational analysis.
Avoid when
Simple flat datasets where a Table is clearer.
Typical data
Row hierarchy, Optional column hierarchy, Measures
Usage
BAF → product group → article, hierarchical operational analysis.
Power BI limitation
Deep hierarchies and too many columns create horizontal/vertical complexity. Validate totals and subtotals carefully.