Microsoft Certified: Fabric Analytics Engineer AssociateExplore and analyze data (15-20%)Medium
A data analyst is building a dashboard in Power BI, connected to a SQL endpoint in a Microsoft Fabric Lakehouse. They need to display sales performance segmented by product category and region, with drill-down capabilities. Which type of visual best supports this hierarchical analysis and segmentation?
- ATable visual
- BCard visual
- CGauge visual
- DMatrix visual
Show answer & explanationAnswer & explanation
Correct answer: D. Matrix visual
A Matrix visual in Power BI is ideal for displaying data hierarchically across multiple dimensions (like product category and region) and aggregating measures. It supports drill-down/up functionality and allows for collapsing and expanding rows/columns, making it perfect for segmented hierarchical analysis.
Why the other options are wrong
- A. A Table visual presents data in rows and columns but lacks the hierarchical grouping and drill-down capabilities of a matrix.
- B. A Card visual displays a single aggregate number, not suitable for segmented or hierarchical analysis.
- C. A Gauge visual shows progress towards a goal or a single KPI, not for multi-dimensional segmentation.
Power BI Matrix Visual
The Power BI Matrix visual is a grid-like chart that supports displaying data across multiple dimensions with hierarchical row and column groupings, enabling drill-down capabilities and aggregated totals.
- Ideal for hierarchical and cross-tabulated data.
- Supports drill-down/up functionality.
- Allows for multiple row and column fields.
- Displays subtotals and grand totals.
Memory trick: Matrix for multi-level data, Card for one number, Table for raw, Gauge for goals.