A pie chart shows how one total splits into parts. It answers one question well: roughly what share does each part have? With a few slices it is quick to read. With many slices it stops working.
How to make a pie chart in Power BI
- In the Report view, click an empty part of the page.
- In the Visualizations pane, select Pie chart.
- Drag a category, such as
Segment, into Legend. - Drag a number, such as
Sales, into Values. - Drag the corners to resize the visual.
That’s the whole chart. On the Financial Sample data, sales by segment look like this:
| Segment | Sales | Share |
|---|---|---|
| Government | 52,504,261 | 44.22% |
| Small Business | 42,427,919 | 35.74% |
| Enterprise | 19,611,694 | 16.52% |
| Midmarket | 2,381,883 | 2.01% |
| Channel Partners | 1,800,594 | 1.52% |
| Total | 118,726,350 | 100% |
Government and Small Business are about four fifths of sales. A pie chart makes that obvious at a glance, and that is its job.
How to show percentages on the slices
- Select the chart, then open Format your visual in the Visualizations pane.
- Open Detail labels and make sure it’s on.
- Under Label contents, choose Percent of total, or Category, percent of total to name each slice.
Once each slice has its name, you can turn off the legend. Readers no longer need to match colors, and the chart gets more room.
How to keep a pie chart readable
- Use few slices. Aim for five or fewer. Above that, the small slices become unreadable.
- Sort by size. Sort the visual by the value so the biggest slice comes first. Use More options (…) > Sort axis.
- Make sure the parts add up to a whole. A pie needs a total that means something. Regions of sales work. Monthly average prices do not.
- Avoid several pies side by side. Comparing angles across charts is hard. Use one stacked bar chart instead.
In the table above, Midmarket and Channel Partners together are under 4% of sales. On a pie they are two thin slivers. That is a warning sign: if the small parts matter to your reader, a pie is the wrong chart.
When a bar chart is better
People compare lengths more accurately than angles. If your reader needs to see the exact order or compare parts that are close in size, use a bar chart. Sorted bars also handle ten or twenty categories easily.
| You want to show | Use |
|---|---|
| A rough share of a total, with a few parts | Pie or donut chart |
| Which category is bigger, or the exact order | Bar chart |
| Many categories | Sorted bar chart or treemap |
| Change over time | Line chart |
For more on this choice, see which Power BI chart to use.
Pie chart or donut chart?
A donut is a pie with a hole in the middle. Both are read the same way, so choose whichever fits your report. The hole is a natural place for a card showing the total.
Why your pie chart looks wrong
- Only one slice: the field in Legend has one value after filters, or a slicer is limiting it.
- Every slice is the same size: you may be counting rows, or the field is set to Average or First. Open the dropdown on the field in Values and choose Sum.
- Blank slice: the category has empty values. Fix them in Power Query, or filter out blanks.
- Negative numbers are missing: a pie can’t draw negative slices. Profit by product, with some losses, belongs in a bar chart.
Sources
- Visualization types in Power BI, Microsoft Learn
- Customize visualization titles, legends and labels, Microsoft Learn
- Doughnut charts in Power BI, Microsoft Learn