All articles

Design · Visuals

Which Power BI chart should you use? A simple guide with examples

Bar, column, line, pie, table, matrix, card or scatter: which Power BI visual to use for each question, when each one breaks, and examples on real sales data.

7 November 2026·2 min read·Sources listed at the end

Design

Choosing a visual isn’t about what looks interesting. It’s about the question. Start with the question, and the chart picks itself.

The short version

The question The visual Why
Which is biggest? Bar chart, sorted Long labels fit, easy to compare lengths
How did it change over time? Line chart The eye follows the line
Few periods side by side? Column chart Good for 3–12 periods
What’s the split of a whole (2–3 parts)? Pie / donut or 100% bar Only works with few parts
What are the exact values? Table For looking things up
Two dimensions at once? Matrix Rows × columns, like a pivot table
One number? Card The headline
How do two measures relate? Scatter chart Each dot is a product or country

Bar chart: comparing categories

Sales by country on the practice data: the United States 25.03M, Canada 24.89M, France 24.35M, Germany 23.51M, Mexico 20.95M. A sorted bar chart shows the ranking at once, and shows that the countries are close. Sort it (largest first). An unsorted bar chart makes the reader do the sorting.

When it breaks: more than about 15 bars. Show the top 10 and group the rest as “Other”.

Line chart: change over time

Sales by month shows the shape of the year and the outliers, like October 2014 at 12.38M. Time always goes left to right.

When it breaks: many lines in different colors (a “spaghetti chart”). Show the one that matters in color and the others in gray, or use small multiples.

Pie chart: parts of a whole, used rarely

A pie works when there are two or three parts and one is clearly larger. With five similar slices (like our five countries, each about a fifth), nobody can tell which slice is bigger. Use a bar chart.

Table and matrix: exact values

Use a table when people need to look up a value, not see a pattern. A matrix adds columns: profit by segment (rows) and country (columns). Add conditional formatting so the pattern still shows.

Card: one number

The headline. See Power BI KPI cards for how to make cards people trust.

Visuals to avoid in business reports

  • 3D charts: they distort sizes.
  • Gauges for everything: they take a lot of space for one number. A card with a target comparison says the same.
  • Maps when location doesn’t matter: five countries are easier to compare in a bar chart than on a map.
  • Dual-axis charts with two unrelated scales: readers compare the heights and draw the wrong conclusion.

Practice it

In The right chart for the question, you rebuild visuals that use the wrong chart type in our Power BI practice simulator. The Visuals stage teaches each chart type hands-on: bar, column, line, pie, table, matrix, card and slicer, all on the same data.

Sources

Practice it

The right chart for the question

Fix a page that uses the wrong visuals: lines for categories, pies with too many slices.

Open the lesson

Read next