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
- Visualization types in Power BI, Microsoft Learn
- Tips for designing a great Power BI dashboard, Microsoft Learn