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 need to display the distribution of customer ages across different product categories. Which Power BI visual is most appropriate for visualizing this data?
- ABar chart
- BScatter chart
- CHistogram
- DLine chart
Show answer & explanationAnswer & explanation
Correct answer: C. Histogram
A histogram is specifically designed to visualize the distribution of a single numerical variable (like customer age) by grouping values into bins and showing the frequency or count of values in each bin. This makes it ideal for understanding how ages are distributed across product categories.
Why the other options are wrong
- A. A bar chart is typically used to compare discrete categories or show counts, but a histogram is more specialized for visualizing the distribution of a continuous numerical variable.
- B. A scatter chart is used to show the relationship or correlation between two numerical variables.
- D. A line chart is best for showing trends over time or ordered categories, not distributions of a single variable.
Histogram Use Case
A histogram is a graphical representation of the distribution of numerical data. It is an estimate of the probability distribution of a continuous variable.
- Used to visualize the distribution of a single numerical variable.
- Data is grouped into 'bins' or ranges.
- The height of each bar represents the frequency or count of data points in that bin.
- Helps identify central tendency, spread, and shape of data distribution.
Memory trick: Histograms show how numbers are spread, like a bar chart for continuous data!