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

To create a pie chart in Power BI, select your data fields, then click the Pie chart icon in the Visualizations pane. Assign a category to the Legend and a numeric value to the Values field to display the chart.

Syntax

Power BI uses a drag-and-drop interface for visuals. The pie chart requires two main parts:

• Legend: The category or group to slice the pie.
• Values: The numeric data that determines slice size.

These fields are assigned in the Visualizations pane after selecting the pie chart icon.

text

1. Select your dataset in Power BI Desktop.
2. Click the Pie chart icon in the Visualizations pane.
3. Drag a categorical field to the Legend area.
4. Drag a numeric field to the Values area.

Example

This example shows how to create a pie chart displaying sales by product category.

text

1. Open Power BI Desktop and load your data (e.g., Sales table).
2. Click the Pie chart icon in the Visualizations pane.
3. Drag the 'Product Category' field to the Legend area.
4. Drag the 'Sales Amount' field to the Values area.
5. The pie chart will display slices sized by sales per category.

Output

A pie chart appears showing colored slices for each product category sized by total sales amount.

Common Pitfalls

• Not assigning a numeric field to Values results in an empty or incorrect chart.
• Using too many categories in Legend can clutter the chart and reduce readability.
• Pie charts are best for showing parts of a whole; avoid using them for unrelated or non-percentage data.

text

Wrong:
- Dragging only a text field to Values (no numeric data).

Right:
- Always drag a numeric field like 'Sales Amount' to Values for meaningful slices.

Quick Reference

Step	Action
1	Load your data into Power BI Desktop
2	Select the Pie chart icon in Visualizations
3	Drag a category field to Legend
4	Drag a numeric field to Values
5	Adjust colors and labels as needed

Key Takeaways

Select the Pie chart visual and assign a category to Legend and a number to Values.

Use numeric data for Values to size pie slices correctly.

Limit categories in Legend to keep the chart clear and readable.

Pie charts best show parts of a whole, not unrelated data.

Customize colors and labels for better visualization.