Comparing five regions' monthly sales with a stacked bar chart

Create reports
Answer Correct answer: B — a stacked bar chart gives five directly comparable bars of absolute sales per region.

You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month. Which visual should you use?

  1. a line chart
  2. a stacked bar chart Correct Answer
  3. a 100% stacked bar chart
  4. a waterfall chart
stacked bar chart category comparison visual selection

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

A bar chart is the canonical compare-across-categories visual; with a single measure per region, its stacked variant renders five directly comparable bars for the current month.

A visual must let users compare the sales performance of five sales regions for the current month, so the chart type must support direct magnitude comparison across categories.

Choosing the 100% stacked variant — it rescales every bar to fill 100% and shows proportional share, destroying the absolute magnitude comparison the requirement asks for.

Community Discussion (5 comments)

jaume 👍 1 Selected: B
It would be even easier with a clustered Bar chart but since this option is not available, let's stick to the stacked version. Not sure why it's not also possible the 100% option; it's my understanding the difference is reporting sales in absolute values or as % of total values, comparison would still be possible
Arth_1111 👍 3 Selected: B
B is correct
Arth_1111 👍 2 Selected: B
Correct answer should be B - Stacked Bar Chart
Jayaruwan 👍 3 Selected: B
Comparing is easy with stacked bar chart than 100% stacked bar chart
Philip9845 👍 1 Selected: B
I chose option B. Crossed checked with chatgpt as well.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Comparing performance across categories is the defining strength of bar charts: each region gets one bar whose length encodes its sales for the current month, making the five regions immediately rankable. The stacked bar chart (B) handles this single-measure comparison perfectly, with each region's absolute value visible and comparable.

Why the Other Options Are Wrong

A line chart (A) emphasizes trends across a continuous axis — the right tool for months over time, but for one month across five discrete regions it produces a misleading line through unrelated categories. A 100% stacked bar chart (C) normalizes bars to equal length, showing each region's share of the total rather than its actual sales, which defeats the comparison goal. A waterfall chart (D) explains how an initial value changes through additions and subtractions — a contribution-flow story, not a ranking of regions.

Community Comment Notes

Commenters agree on B, with one noting a clustered bar would be the natural pick but the stacked variant is the closest listed option. Another stresses that comparison is easier on a stacked bar than a 100% stacked bar because absolute lengths remain meaningful.

Official Reference

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-visual-type

Related Analysis

You have a Microsoft Excel file in a Microsoft OneDrive fold

S-Grade

You have a Power BI semantic model named Model1 that contain

S-Grade

You use Power Query Editor to preview a column named Date as

S-Grade

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide