Power BI Donut Chart

Power BI Donut Chart is similar to Pie, which is useful for visualizing higher-level data. In this article, we show you how to Create a Donut Chart with an example.

For this Power BI Donut Chart demonstration, we are going to use the SQL Data Source that we created in our previous article.

Please refer to Connect to SQL Server article to understand the Power BI Data Source.

How to Create a Donut Chart in Power BI

When you click on this under the Visualization section, it automatically creates a Donut Chart with dummy data.

Power BI Donut Chart 1

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.
  • Values: Any Numeric value such as orders, sales amount, Total Sales, Customer count, etc.

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

Add Measure to value Field 2

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.

Power BI Donut Chart 3

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

Approach 2

First, Drag and Drop the Order Quantity from the Fields section to Canvas. It automatically creates a Column.

Choose the Order Quantity Measure Field 4

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.

Add Product Dimension to Axis 5

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

Add Legend Value 6

By adding another field to the Details section, further, divide the Power BI Donut Chart.

Add Legend 7

Let me do some quick formatting to it. I suggest you refer to the Format article to understand the steps involved in formatting the Title font, Title alignment, Data labels, Legend titles, Slice color, and background colors.

Power BI Donut Chart 8

Donut Chart FAQ’s

How do you make a Donut Chart in Power BI?

Click on the doughnut chart icon in the Visualization pane to display a sample. In addition, adding Sales to Values and dimension field (category) to the legend will generate an actual donut chart.

What is the Difference Pie Chart and Donut Chart?

A pie chart uses slices to compare different categories or segments. A donut chart looks and acts identical to a pie chart, but as the name suggests, it has a hole in the center.

What can I use instead of a donut chart?

Pie Chart, or you can also choose the bar or column chart.

What are doughnut charts best for?

When comparing 2 to 4 segments or categories, use a donut chart.

What is the drill down donut chart in Power BI?

Use any category or segment hierarchy (more than one field) as the legend field. The desktop will automatically create a drill-down action.

Comments are closed.