Power BI Donut Chart is similar to Pie Chart, which is useful to visualize the higher-level data. In this article, we show you how to Create a Donut Chart in Power BI with example.
For this Donut Chart in Power BI demonstration, we are going to use the SQL Data Source that we created in our previous article.
Please refer to Connect Power BI to SQL Server article to understand the Power BI Data Source.
How to Create a Donut Chart in Power BI
When you click on the Donut Chart under the Visualization section, it automatically creates a Donut Chart with dummy data.
To add data to the Power BI Donut Chart, we have to add the 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 the Axis section. You can do this by dragging Category to Axis, or checkmark the category column.
From the above screenshot, you can see the Donut Chart of Order Quantity that is Sliced by Product Category.
Create a Donut Chart in Power BI – Approach 2
First, Drag and Drop the Order Quantity from Fields section to Canvas. It automatically creates a Power BI Column Chart.
Next, let me add the English Product Category Name from DimProductCategory Table to the Axis section. For this, drag and drop Category to Axis, or checkmark the category column.
By clicking the Donut Chart under the Visualization section automatically convert the Column Chart into Donut Chart
By adding another field to Details section further divide the Power BI Donut Chart.
Let me do some quick formatting to the Donut Chart
NOTE: I suggest you to refer to the Format Donut Chart article to understand the steps involved in formatting the Title font, Title alignment, Data labels, Legend titles, Slice color, and background colors.
