Bar and column charts in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main difference between a bar chart and a column chart?

A bar chart displays data with horizontal bars, while a column chart uses vertical bars. Both show comparisons, but orientation differs.

beginner

When should you use a bar chart instead of a column chart?

Use a bar chart when category names are long or when you have many categories, as horizontal bars fit labels better.

beginner

How do bar and column charts help in business intelligence?

They help compare values across categories quickly, making trends and differences easy to see for decision making.

intermediate

What is a stacked column chart?

A stacked column chart shows parts of a whole for each category by stacking segments in each column, helping compare totals and parts.

beginner

Name one accessibility best practice when creating bar or column charts.

Use clear labels and high-contrast colors so everyone, including people with vision difficulties, can understand the chart.

Which chart orientation uses vertical bars?

A Bar chart

B Line chart

C Pie chart

D Column chart

Column charts use vertical bars to represent data.

What is a good reason to choose a bar chart over a column chart?

A When category labels are long

B When you have only two categories

C When you want to show trends over time

D When you want to show parts of a whole

Bar charts handle long category labels better because they are horizontal.

What does a stacked column chart show?

A Only total values per category

B Parts of a whole within each category

C Data points over time

D Relationships between two variables

Stacked column charts show how parts add up to a total in each category.

Which is NOT a best practice for bar and column charts?

A Keep bars proportional to values

B Use clear axis labels

C Use too many colors randomly

D Use high contrast colors

Using too many random colors can confuse viewers and reduce clarity.

What is the main purpose of bar and column charts in BI?

A To compare values across categories

B To show detailed data tables

C To display geographic data

D To show text summaries

Bar and column charts help compare values across different categories visually.

Explain when and why you would use a bar chart instead of a column chart in a business report.

Think about label length and orientation.

Describe how a stacked column chart can help show data differently than a simple column chart.

Focus on how data segments relate to totals.