Power BI Donut Chart

Power BI Donut Chart is similar to Pie Chart which is used to visualize the higher level data. In this article we will show you, How to Create a Donut Chart in Power BI with example.

For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.

How to Create a Power BI Donut Chart

When you click on the Donut Chart under the Visualization section, it will automatically create a Donut Chart with dummy data as shown in below screenshot.

In order to add data to Donut Chart, we have to add required fields:

• Legend: Drag and drop the column that you want to display as the legend.
• Details: Drag and drop the Column on which you want to partition your Donut Chart.
• Values: Any Numeric value such as orders, sales amount, Total Sales, Customer count etc.

Let me drag and drop the Order Quantity from Fields section to Values field.

Next, let me add the English Product Category Name from DimProductCategory Table to Axis section. You can do this by dragging Category to Axis, or simple check mark the category column.

From the above screenshot, you can see the Donut Chart of Order Quantity that is Sliced by Product Category.

Create a Power BI Donut Chart – Approach 2

First, Drag and Drop the Order Quantity from Fields section to Canvas. This will automatically create a Column Chart as shown in below screenshot.

Next, let me add the English Product Category Name from DimProductCategory Table to Axis section. This can be done by drag and drop Category to Axis, or simple check mark the category column.

By clicking the Donut Chart under the Visualization section will automatically convert the Column Chart into Donut Chart

By adding another field to Details section will further divide the Donut Chart.

Let me do some quick formatting to the Donut Chart

NOTE: I suggest you to refer Format Donut Chart article to understand the steps involved in formatting the Title font, Title alignment, Data labels, Slice color, and background colors.

Thank You for Visiting Our Blog