Pie, Donut and Treemap Charts
Pie charts, donut charts, and treemaps help users understand how categories contribute to a total. These visuals are useful for showing proportions, category shares, and the relative size of different groups in a dataset.
Learning Objectives
- Understand the purpose of pie charts, donut charts, and treemaps.
- Assign category and numeric fields to the correct visual roles.
- Interpret category proportions and contribution to totals.
- Format labels, legends, titles, and colors effectively.
- Recognize when another chart type is a better choice.
1. Understanding Part-to-Whole Charts
A part-to-whole chart shows how individual categories contribute to a complete total. For example, a business might use one to display the percentage of sales generated by each product category.
Example: Product Sales Contribution
2. Pie Chart
A pie chart represents a total as a circle divided into slices. Each slice corresponds to a category, and its size represents that category's share of the total.
Sales Share by Category
How to Create a Pie Chart
- Select an empty area on the report canvas.
- Choose the Pie Chart visual from the Visualizations pane.
- Add a categorical field, such as Product Category, to the Legend or category field well.
- Add a numeric field, such as Sales Amount, to Values.
- Check that the values are aggregated correctly.
- Format the title, legend, data labels, and colors.
3. Donut Chart
A donut chart is similar to a pie chart, but it has an empty center. The center can provide visual space for a title or a separate label added to the report. The chart still represents category shares.
Donut Chart Example
When to Use a Donut Chart
- When showing a small number of categories as shares of a total.
- When a center label helps communicate a key message.
- When the report design benefits from a compact circular visual.
4. Treemap Chart
A treemap represents categories as nested rectangles. The area of each rectangle corresponds to the value assigned to that category. Treemaps are useful for displaying many categories in a limited space.
Sales by Product Category
How to Create a Treemap
- Select the Treemap visual.
- Drag a category field, such as Product Category, into the category or Group field well.
- Drag a numeric field, such as Sales Amount, into Values.
- Optionally add a second category field to create grouped rectangles.
- Format data labels, colors, and titles for readability.
5. Compare the Three Visuals
| Visual | Main Strength | Potential Limitation |
|---|---|---|
| Pie Chart | Shows proportions of a total | Many slices are difficult to compare |
| Donut Chart | Shows proportions with an open center | Small differences may be hard to judge |
| Treemap | Displays many categories in a compact area | Precise comparison between similar areas can be difficult |
| Bar Chart | Often better for precise category comparisons | May need more space for many categories |
6. Understand the Data Fields
These visuals generally need a categorical field to define the groups and a numeric field to calculate the size of each group. The available field wells can vary with the visual and Power BI version.
From Data to Proportion
7. Formatting and Readability
- Use a meaningful title that explains what the chart represents.
- Keep category names short and understandable.
- Use consistent colors for the same categories across the report.
- Show data labels when they improve interpretation.
- Use percentage labels when the purpose is to show shares.
- Do not rely on color alone; include readable category names.
- Check that blank, negative, or unexpected values are handled appropriately.
8. Practice Activity
Scenario: Department Sales
| Department | Sales Amount |
|---|---|
| Electronics | 45,000 |
| Clothing | 25,000 |
| Food | 20,000 |
| Home Goods | 10,000 |
Tasks
- Create a pie chart showing sales by department.
- Create a donut chart using the same fields.
- Create a treemap and compare the relative sizes of the departments.
- Add meaningful titles and data labels.
- Decide which visual is easiest to interpret and explain why.
9. Knowledge Check
Question 1: Which visual is designed to show categories as rectangles whose areas represent values?
A. Treemap
B. Line chart
C. Scatter chart
Question 2: What does a slice in a pie chart represent?
A. A category's contribution to the total
B. A report page
C. A column's data type
Question 3: What should you consider when a chart contains many categories?
A. Whether the visual remains readable
B. Whether every category has a different font
C. Whether the title is removed
Show Answers
- Question 1: A — Treemap.
- Question 2: A — A category's contribution to the total.
- Question 3: A — Whether the visual remains readable.
Summary
In this lesson, you learned how pie charts, donut charts, and treemaps represent category contributions to a total. You practised assigning category and numeric fields, interpreting proportions, and formatting visuals for clear communication.
Choose a part-to-whole visual when category share is the main message. When users need precise comparisons or many categories make the visual difficult to read, consider using a bar chart instead.