How to Create & Use Donut Chart in Power BI?

In this Power BI article, we will learn what is donut chart in Power BI, when to use donut chart in Power BI, Power BI donut chart conditional formatting, and Power BI donut chart with total in center with examples.

Also, we will cover some more topics below:

  • How to create a donut chart in Power BI
  • Difference between a pie chart and a donut chart in Power BI
  • Power BI donut chart percentage
  • Power BI multi-level donut chart

What is Donut Chart in Power BI

Power BI Donut chart is similar to the Pie chart but with a hole in the center. It is useful for visualizing higher-level data.

It represents data using slices of the donut, with each slice showing the proportion of a category relative to the whole.

Donut chart in Power BI

When to use donut chart in Power BI

A doughnut chart in Power BI is most effective when used to compare a specific section to the entire system rather than individual sections to one another.

How to create a donut chart in Power BI

Here, we will see how to create a donut chart in Power BI.

For example, we will use the sales Excel table to create a donut chart in Power BI.

donut visual in power bi
  • Open Power BI Desktop, click on the Excel workbook, and select the table from your local system.
  • Next, select the Donut chart from the Power BI visualization pane.
  • Now, you can see a blank donut chart is added to the canvas.
powerbi donut chart
  • Then drag and drop the Product Category and Sales to Legend and Values respectively.
  • Now you can see the Donut chart in Power BI is showing Sales by product category.
donut chart powerbi

Difference between a pie chart and a donut chart in Power BI

Here, we will see the difference between a pie chart and a donut chart in Power BI.

Pie chartDonut chart
The pie chart in Power BI does not have a hole in the center. The entire circle is filled with data slices.Donut charts in Power BI have a hole in the center, surrounded by data slices.
The center of a pie chart is typically left empty and does not represent any data.The center of a donut chart can sometimes be utilized for additional information, such as displaying total revenue or labeling categories.
Pie charts usually have labels placed outside the chart near each sliceDonut charts often feature labels inside the center hole, which saves space and reduces the chance of overlap.
Donut charts are good for showing multiple data series together because each ring can represent a different seriesPie charts are widely used to show the structure of a single data series.

Refer to this article to know more details: Difference Between Pie Chart and Donut Chart in Power BI

See also  Power Automate Filter Query If Blank [With Example]

Power BI donut chart with total in center

Here, we will see how to create a donut chart with the total in the center in Power BI.

In this example, we will use the same Sales table and create a donut chart that shows total sales in the center, as shown below.

power bi donut chart with total in center

Unfortunately, Power BI doesn’t provide any formatting to show labels in the center of the donut chart.

So, I will give you an idea for showing the total label in the center of the donut chart. Follow the below steps.

  • In Power BI Desktop, load the data using the Get Data option.
  • We will create a card; for this, select the card from the visualization pane.
  • Then drag and drop the Sales field to the Fields. Now you can see the total sales.
when to use donut chart in power bi
  • Next, we will create a Donut chart; for this, select the Donut chart from the visualization pane.
  • Then drag and drop the Product Category and Sales to Legend and Values respectively.
donut chart powerbi
  • Next, bring the card visual on top of the Donut chart visual in the canvas.
  • Then select the Format pane, toggle off the Category label in the visual section, and then click on the General option.
  • Expand the Effect section, then expand the Background section, and make the Transparency 100%.
when to utilise power bi doughnut chart
  • Then click on the View tab, select the Selection, and bookmark pane.
  • Now select both the visuals in the canvas, then click on the more icon in the selection pane.
  • Then select Group and select Group. Now, both are coming under a single group.
what is donut chart in power bi
  • In the Bookmark pane, click on the Add button; it will save the current state by creating a new bookmark.
  • Now, you can see the total sales in the center in the Power BI donut chart.
power bi donut chart total in center

This is an example of a donut chart with the total in the center in Power BI.

Power BI donut chart percentage

Here, we will see how to show the percentage in the Power BI Donut chart.

See also  Power bi measure subtract + 7 useful examples

Using the Sales Excel table, we will create a Donut chart in Power. Then, with the help of a detail label, we will show the percentage for each category, as shown below.

power bi doughnut chart

To do this, follow the below steps:

  • In Power BI, create a Donut chart and then drag and drop the Product Category and Sales to Legend and Values, respectively.
donut chart percentage
  • Next, click on the format pane and then expand the Detail label. Select the Label content as ‘Content, percent of total.’
  • Now, you can see the percentage based on the category in the Power BI Donut chart.
Power BI donut chart percentage

This is an example of a Power BI donut chart percentage.

Conditional formatting donut chart Power BI

Here, we will see how to format the slices of a Donut chart. Unfortunately, in Power BI, the Donut chart lacks a conditional formatting option to change slice colors based on conditions.

However, I’ll guide you on how to change the colors of Power BI Donut chart slices.

For example, we will use the same Sales Excel table to create a Donut chart.

We will display the sales based on the segment in the Power BI Donut chart. As a Donut chart, we cannot format the slices, so here we will convert the Donut chart to a bar chart, or you can directly create the bar chart. Then, we will apply the conditional formatting to it and convert it to a Donut chart.

conditional formatting donut chart power bi

Now, let’s see how we can apply the conditional formatting to slices of the Power BI Donut chart.

  • Open Power BI Desktop, and Load the data using the Get data option.
  • Select the Stacked bar chart from the visualization pane to create the bar chart.
  • To show the sales based on segment, drag and drop the Sales and Product Category columns to the X and Y axes, respectively.
how to change chart color in power bi
  • Next, click on the Format pane, then expand the Bar section.
  • Click on the fx in the color section.
how to change color of donut chart in power bi
  • It will open the Conditional Formatting window. Here, select the Format style as a Gradient.
  • Select the Sales field in ‘What field should we base this on, ‘and select Sum as Summarization.
  • Next, ‘How should we format empty values‘ as ‘As zero‘.
  • Then, in Minimum value, select Custom from the dropdown and enter 2000. Select the color.
  • For the Maximum value, select Custom from the dropdown and enter the value as 3500. Select the color
  • Also, you can enable the middle value by checking the box to add a middle color. Then click on OK.
how to change data color in power bi
  • Now you can see the color formatting is applied to the bar chart in Power BI.
  • Select the Donut chart from the visualization pane to convert the bar chart to a Donut chart.
power bi donut chart conditional formatting

This is how we can apply conditional formatting to the donut chart in Power BI.

See also  Power Automate Skip Function

Power BI multi-level donut chart

Here, we will see how to create a multi-level donut chart in Power BI

Using the same sales table, we’ll calculate the target percentage for each category based on the given target (5000).

Then, we’ll find the target difference, which is 1 – the target percentage. After that, we’ll create a multi-layered donut chart where each layer shows the target difference and target percentage for each category.

multi layer donut chart in power bi
  • Open Power BI Desktop and load the data using the “Get data” option.
  • Next, create the following measures to calculate Total Sales, Target Percentage, and Target Difference.
Total Sales = SUM('Sales (2)'[Sales])
Target% = [Total Sales]/5000
Target Diff = 1-[Target%]

Next, create a donut chart, and then add the “Target %” and “Target Diff” measure to the values.

doughnut chart power bi
  • Add ‘Product Category’ to the ‘Add data field’ in the Filter pane for this visual section. Then, choose ‘Home’ from the Product Category
double donut chart power bi

Next, click on the Format pane and follow these steps:

  • Turn off the Legend.
  • Disable the data labels.
  • In the Slices section, adjust the slices’ color, then go to the Spaces section and increase the inner radius.
power bi multi level donut chart

First, copy the visual and paste it twice. Next, resize both copies to make them smaller and position them inside the donut chart.

Then, follow these steps to format both charts:

  1. Go to the Format pane and click on the General tab. Toggle off the Title.
  2. Expand the Effect section, then expand the Background and increase the transparency.
  3. Change the color of the slice representing the target percentage.
  4. In the Filter pane, select the left category for each donut chart.
how to create donut chart in power bi


Next, create 3 card visuals containing the “Target %” measure in the Fields. Then, in the Format pane, expand the ‘Callout value’ section and decrease the font size.

doughnut chart in power bi
  • Based on the card visual, select the product category from the Filter pane. Then, add the product category to the filter for each card visual. Refer to the screenshot below.
  • Rename the visual based on the filtered category.
power bi donut

Click on the Insert tab, then select Shapes from the dropdown menu, and choose the rectangle.

how to use donut chart in power bi


Next, resize it to be smaller and expand the Style section. Then, choose a color for the Fill that matches the donut chart.

multi layer donut chart power bi

Some more articles you may also like:

Conclusion

In this Power BI tutorial, we saw the Donut chart in Power BI, when to use donut chart in Power BI, how to create a donut chart in Power BI, and many more:

  • Pie chart vs Donut chart in Power BI
  • Power BI donut chart with total in the center
  • Power BI donut chart percentage
  • Working with Power BI multi-level donut chart
  • Various conditional formatting donut chart Power BI
  • >