A healthcare provider is analyzing patient readmission rates using Power BI. The dataset includes 'Patient ID', 'Admission Date', 'Discharge Date', and 'Readmission Flag' (True/False). The analyst wants to create a visual that shows the number of readmissions each month and also compare it against the average monthly readmission rate over the past year. The visual should clearly distinguish the current month's performance from the historical average. Which visual composition achieves this most effectively?
- APie Chart showing the proportion of readmissions to average.
- BTable visual with two columns for monthly and average readmissions.
- CStacked Bar Chart with readmissions and average as separate segments.
- DClustered Column Chart showing monthly readmissions and a Line Chart overlaid for the average.
Show answer & explanationAnswer & explanation
Correct answer: D. Clustered Column Chart showing monthly readmissions and a Line Chart overlaid for the average.
A clustered column chart is excellent for showing discrete values like monthly readmissions. Overlaying a line chart for the average readmission rate effectively provides a clear benchmark for comparison. This combination, a combo chart, allows for easy visual distinction between the actual monthly count and the continuous average, often using a secondary Y-axis for scale if needed.
Why the other options are wrong
- A. A pie chart shows proportions of a whole, not trends over time or comparisons against an average.
- B. A table visual provides numerical detail but lacks the immediate visual impact for trend and comparison that a chart offers.
- C. A stacked bar chart would combine the two values, making it difficult to directly compare the monthly count against the average.
Column and Line Combo Chart
A Power BI visual that combines a column chart and a line chart on the same axes, often used to compare two related measures where one might be discrete counts and the other a continuous average or target.
- Good for showing actual vs. target/average.
- Columns for individual period values, line for trend/average.
- Can use dual Y-axes for different scales.
Memory trick: Columns for Now, Line for History's Flow