Microsoft Certified: Fabric Analytics Engineer AssociateExplore and analyze data (15-20%)Easy
A data analyst is building a Power BI report connected to a Lakehouse SQL endpoint in Microsoft Fabric. They want to create a visual that displays the distribution of customer ages, grouped into 5-year bins (e.g., 0-4, 5-9, 10-14, etc.). Which Power BI visual type is most suitable for effectively visualizing this binned numerical data?
- APie chart
- BColumn chart
- CLine chart
- DTable
Show answer & explanationAnswer & explanation
Correct answer: B. Column chart
A column chart is ideal for displaying the distribution of a single numerical variable that has been grouped into bins or categories. Each column represents a bin, and its height indicates the frequency or count of values within that bin, making it easy to compare frequencies across age groups.
Why the other options are wrong
- A. A pie chart is used for showing proportions of a whole, typically for a small number of categories, and can be hard to compare across many bins.
- C. A line chart is best for showing trends over time or continuous categories, not discrete distributions.
- D. A table displays raw data or aggregated numbers but doesn't visually represent distribution effectively.
Column Chart for Distribution
A Power BI visual type that uses vertical bars to represent the frequency or count of items within discrete categories or numerical bins, ideal for showing data distribution.
- Each bar represents a category or bin.
- Height of the bar indicates frequency or count.
- Effective for comparing magnitudes across distinct groups.
- Often used as a histogram for binned numerical data.
Memory trick: Bins need Columns to show their Counts, clearly and distinctly.