All articles

Visuals

Pie chart in Power BI: how to build one and when not to

How to create a pie chart in Power BI, show percentages on each slice, keep it readable, and decide when a bar chart would work better.

9 November 2026·3 min read·Sources listed at the end

Sales by SegmentGovernment44.2%Small Business35.7%Enterprise16.5%Midmarket2.0%Channel Partners1.5%

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

  1. In the Report view, click an empty part of the page.
  2. In the Visualizations pane, select Pie chart.
  3. Drag a category, such as Segment, into Legend.
  4. Drag a number, such as Sales, into Values.
  5. 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

  1. Select the chart, then open Format your visual in the Visualizations pane.
  2. Open Detail labels and make sure it’s on.
  3. 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

Practice it

Parts of a whole: pie charts

Show how a total splits into a few parts, and know when not to.

Open the lesson

Read next