How to Create a Pie Chart in Power BI

Creating a pie chart in Power BI is a straightforward way to show how different parts make up a whole. This guide will walk you through the entire process, from preparing your data and building the chart to customizing it for maximum clarity and avoiding common mistakes that can make pie charts misleading.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is a Pie Chart? A Quick Refresher

A pie chart is one of the most recognizable data visuals. It's a circular graph that is divided into slices to illustrate numerical proportion. Each slice represents a category, and the size (or arc length) of that slice is proportional to the quantity or percentage it represents. In short, it’s designed to answer one question: "What percentage of the total does each category represent?"

You normally see them used to show things like:

• Market share distribution among competitors.
• Budget allocation across different departments.
• Survey results, like the breakdown of responses to a multiple-choice question.
• Sales contribution by different product categories.

The entire pie always represents 100%, and the collective slices add up to that total. It's a simple, intuitive visual that most non-technical stakeholders can understand at a glance, making it a popular choice for high-level reports.

When Should You Use a Pie Chart in Power BI? (And When You Shouldn't)

Just because you can use a pie chart doesn't always mean you should. Its strength lies in its simplicity, but that same simplicity can become a weakness if the data doesn’t fit. Understanding its ideal use cases will make your reports far more effective.

The Best Times to Use a Pie Chart

Stick to a pie chart when your primary goal is to show simple proportions and your data meets these conditions:

• You have a small number of categories: Pie charts are most effective with five or fewer slices. Any more than that and the chart becomes cluttered and difficult for the human eye to distinguish between the slice sizes. If you have many small categories, consider grouping them into a single "Other" slice.
• The values must add up to 100%: The fundamental concept of a pie chart is parts of a whole. If your categories are not mutually exclusive or don't represent the complete picture, a pie chart is the wrong visual.
• You are not showing changes over time: Pie charts provide a static snapshot of your data at a single point in time. For showing trends, use a line chart or an area chart.
• Proportions are significantly different: Pie charts are great when you want to highlight a large disparity between categories, such as one category making up 70% of the total. Our eyes can easily spot the difference between a huge slice and a few small ones.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

When to Avoid Pie Charts and What to Use Instead

Pie charts get a bad reputation among data visualization experts for a reason - they are often misused. Avoid them in these scenarios:

• Comparing Categories with Similar Values: Humans are not good at accurately comparing angles. If you have categories that are 20%, 23%, and 25% of the total, it will be nearly impossible for a viewer to tell which slice is biggest without data labels. A simple bar chart or column chart makes this comparison instantly clear, as we are much better at comparing lengths.
• Displaying More Than Five or Six Categories: When you have many categories, the pie chart turns into a rainbow-colored mess of tiny, unreadable slivers. This is often called a "clown chart." In this case, a horizontal bar chart is almost always a better choice because it can elegantly handle many categories without becoming illegible.
• Needing Precise Comparisons: If the exact values matter more than the general proportion, a simple table or a bar chart with data labels will communicate the detailed numbers more effectively.
• Showing Data with Negative Values: Pie charts cannot represent negative or zero values. A part of a whole cannot be negative.

Step-by-Step: How to Create a Pie Chart in Power BI

Now, let's get into the practical steps. Before you start, make sure you have Power BI Desktop installed and have already loaded the dataset you want to visualize. For a pie chart, your data should ideally have at least one categorical column (what you want to measure) and one numerical column (the measurement itself).

Let's use a sample dataset of product sales:

Sample Data:

• Column 1 (Category): Product Category (e.g., Electronics, Apparel, Home Goods, Books)
• Column 2 (Value): Total Sales (e.g., $500,000, $300,000, $150,000, $50,000)

Here’s how to turn that data into a pie chart.

Step 1: Select the Pie Chart Visual

On your Power BI report canvas, look at the Visualizations pane on the right-hand side. Find the icon that looks like a pie chart and click on it. An empty visual template will appear on your canvas.

Step 2: Drag and Drop Your Data Fields

With the empty pie chart visual selected, you'll see a few "wells" or fields in the Visualizations pane that need data. For a basic pie chart, you only need to focus on two:

• Legend: This is where your categorical data goes. The values in this column will determine the individual slices of the pie. Drag your Product Category field from the Data pane into the Legend well.
• Values: This is for your numerical data. The numbers in this column will determine the size of each slice. Drag your Total Sales field into the Values well.

As soon as you drop both fields in, the pie chart will automatically render on your canvas. Power BI will calculate the sum of sales for each product category and represent it as a slice proportional to the total.

Customizing Your Power BI Pie Chart for Clarity

A default chart gets the job done, but a well-formatted chart tells a much clearer story. To customize the appearance, select your pie chart and click the paintbrush icon ("Format your visual") in the Visualizations pane.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

1. Slices and Colors

Under the Slices dropdown, you can manually change the color of each slice. This is incredibly useful for aligning the report with your company's brand colors or for using color to draw attention to a specific slice. Instead of sticking with the defaults, choose colors that are distinct and easy on the eyes.

2. Detail Labels

This is arguably the most important formatting option for a pie chart. The default labels can be messy, but you have full control.

• Position: You can choose to place your labels Inside or Outside the pie slices. "Outside" is often the cleaner choice, as it prevents text from cramping the smaller slices.
• Label Contents: This lets you decide what information each label shows. Click on this dropdown to see options like:

A great practice is to select a combination that provides a complete picture, such as "Category, percent of total." This often gives the audience all the context they need without having to refer back to the legend.

3. Legend

Under the Legend section, you can change its position (Top, Bottom, Right Center, etc.) or turn it off entirely. If you’ve configured your detail labels to show the category name on each slice, turning the legend off can free up valuable space and make your report look less cluttered.

4. Title

Power BI automatically generates a title based on the data fields you used, like "Sum of Total Sales by Product Category." Always change this to something more descriptive and human-friendly, such as "Total Sales Breakdown by Product Category." A clear title sets the context immediately for your viewers.

5. Rotation

The Rotation option allows you to rotate the entire pie chart. While it sounds simple, this can be used strategically to place the largest slice at the top (starting at the 12 o'clock position) for better emphasis or to prevent data labels from overlapping.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Common Mistakes to Avoid

Building a pie chart is easy, but building a good pie chart requires avoiding a few common pitfalls that can confuse your audience.

• Crowding the Chart: As mentioned before, don't use more than five or six slices. If your data has more categories, group the smallest ones into an "Other" category using Power Query or DAX before building the chart.
• Using Similar Colors: If your slice colors are too similar (like light blue and light teal), it can be difficult for viewers to distinguish between them, especially in the legend. Aim for contrast.
• Forgetting to Sort: An unsorted pie chart can look random. Most conventions suggest sorting the slices from largest to smallest, clockwise. In Power BI, you can sort the chart by clicking the three dots (...) in the top right corner of the visual, selecting "Sort by," and choosing your value field.
• Hiding Important Information: Make sure your data labels are clear and contain the necessary context (like the category name and percentage). Don’t force your viewers to do mental guesswork to understand your chart.

Pro-Tip: Use a Donut Chart Instead

In the Visualizations pane, right next to the pie chart, is the donut chart. It's essentially a pie chart with a hole in the middle, and many data experts prefer it. Why? The empty center de-emphasizes the use of angles and makes viewers focus more on the arc length of each slice, which can make comparisons slightly easier. Even better, that empty space is perfect for placing a KPI card showing the absolute total, making your visual even more informative.

Final Thoughts

The pie chart, when used correctly, is a powerful tool for showing part-to-whole relationships in your data. By understanding its strengths and weaknesses, you can build clear, insightful visuals in Power BI that effectively communicate your story. Mastering the fundamentals of charts like these is a key step in making better data-driven decisions.

While tools like Power BI are incredibly powerful, they still come with a learning curve. You need to understand how fields, formatting panes, and different visual types work together. Here's where we make things simpler. At Graphed , we’ve eliminated that complexity by allowing you to create dashboards using plain English. Instead of dragging and dropping fields, you can just ask, "Show me a pie chart of sales by product category," and our AI data analyst builds it for you in seconds with your data automatically connected.