Pie Chart in Power BI

A pie chart is a circle divided into slices, where each slice represents a category’s share of one whole. The bigger the slice, the bigger that category’s share. It is one of the most recognizable ways to show proportions, which is exactly why it gets overused, and also why it gets criticized so often.

A pie chart only works when your values genuinely add up to one total. If your categories do not represent parts of a single whole, a pie chart will visually imply a relationship that is not actually there.

Step by Setp Process of Creating Pie Chart in Power BI

Step 1: Add a Pie Chart to the Report

In the Visualizations pane, click the Pie Chart icon. This adds an empty pie chart visual to the report canvas.

Step 2: Add a Field to Values

In the Visualizations pane, drag the number you want to measure, such as sales or count, into the Values section. This decides how large each slice is.

Step 3: Add a Field to Legend

Drag the field you want to split your data by, such as product category or region, into the Legend section. This is what turns one solid circle into separate colored slices.

Step 4: Format the Chart and Turn On Data Labels

Click the Format icon to open the Format pane. Look for Data Labels and switch it on. This prints the value or percentage directly on each slice.

Choosing the Right Data Labels

By default, a pie chart only shows the category name on each slice, which leaves people guessing at the actual numbers. In the Format pane, under Data Labels, the Label contents dropdown lets you choose Category, Data value, Percent of total, or a combination such as Category and percent of total, which is usually the single most useful option since it shows both what the slice is and how big its share actually is, without needing to check a legend at all.

It is also worth turning the legend off entirely once your labels are on the slices themselves. Reading a label directly on its slice is faster than glancing back and forth between a slice and a separate legend, and for a small number of categories, the slices alone carry enough information on their own.

Pie Chart vs Donut Chart Comparison

A pie chart and a donut chart plot the same kind of data with the same Values and Legend fields, and the choice between them mostly comes down to style. A donut chart has a hollow center that can hold a total or a short label, which a pie chart cannot do since it uses the full circle for its slices. If you want that extra label in the middle, use a donut chart. Otherwise a plain pie chart is simpler and just as effective.

When to Use a Pie Chart, and When Not To

• Use it when you have a small number of categories, ideally 5 or 6 or fewer, that genuinely add up to one whole.
• Use it when the slices are noticeably different in size. If two categories are close in share, a pie chart makes it hard to tell which is actually larger without reading the labels.
• Avoid it once you have more than about 6 or 7 categories. At that point a bar chart handles the same comparison far more clearly.
• Avoid it when precise comparison between categories matters more than the general shape of the split. A bar chart is easier to read accurately than judging the angle of a slice.

Common Mistakes to Avoid

• Too many slices. Once you pass 6 or 7 categories, group the smaller ones into an Other slice rather than letting the chart turn into a ring of slivers.
• Similar colors on adjacent slices. If two categories are hard to tell apart by color, readers lose track of which slice is which the moment they look away and back.
• Leaving labels off, or off on tiny slices. A slice below a few percent of the total may not show a label at all if space runs out. If that category still matters to your audience, group it into Other or switch to a bar chart instead.

Using a pie chart when the numbers do not add up to a whole. If your categories overlap or measure different things entirely, a pie chart implies a part to whole relationship that does not actually exist in your data.

That covers building, formatting, and choosing a pie chart in Power BI. To keep building out your report with other chart types, explore Prwatech’s Power BI training program, which includes placement assistance.