Creating a pie chart in Power BI is straightforward. Follow these steps:
1. Open Power BI Desktop:
Launch Power BI Desktop on your computer.
2. Load Your Data:
Click on Home > Get Data.
Choose your data source (e.g., Excel, SQL Server, etc.) and load your data into Power BI.
3. Insert a Donut Chart
Go to the Report View (default view in Power BI).
In the "Build" pane, click on the "Donut Chart" icon.
Drag the Donut Chart onto the canvas.
4. Assign Data Fields
Drag the categorical field (e.g., Region, Category, Subcategory) into the "Legend" section.
Drag the numerical field (e.g., Sales Volume, Customer count) into the "Values" section.
5. Customize the Donut Chart
Colors & Labels: Click on the "Format" (paint roller icon) in the Visualizations pane.
Enable Data Labels to display values.
Adjust Colors to match your theme.
Title: Under Format, edit the Title for clarity.
Legend: Adjust placement if needed.
6. Save & Publish
Click "Save" to store your Power BI file.
If publishing to Power BI Service, click "Publish" in the Home tab.
We have a dataset with Sales and Region. Here's how you might set it up:
Load Data:
Load your dataset containing Region, Sales.
Insert Donut Chart:
Click on the "Donut Chart" icon in the "Build" pane.
Configure Chart:
Use for those values which are less than 5
Drag "Region" to "Legend".
Drag "Sales" to the "Values".
Customize:
Use the Format pane to adjust colors, add data labels, and customize the chart title.
(Values all detail lables)
Data Labels: Enable data labels to show the values on each segment of the Donut Chart.
Tooltips: Customize tooltips to provide more information when hovering over the Donut Chart.
By following these steps, you should be able to create a clear and informative Donut Chart chart in Power BI.