Create and use doughnut charts in Power BI

APPLIES TO: Does not apply to.Power BI service for consumers Applies to.Power BI service for designers & developers Applies to.Power BI Desktop Does not apply to.Requires Pro or Premium license

Note

Smart narrative visuals can be created and viewed in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.

A doughnut chart is similar to a pie chart in that it shows the relationship of parts to a whole. The only difference is that the center is blank and allows space for a label or icon.

Prerequisite

This tutorial uses the Retail Analysis sample PBIX file.

  1. From the upper left section of the menubar, select File > Open

  2. Find your copy of the Retail Analysis sample PBIX file

  3. Open the Retail Analysis sample PBIX file in report view Screenshot of the report view icon..

  4. Select Screenshot of the yellow tab. to add a new page.

Note

Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.

Create a doughnut chart

  1. Start on a blank report page and from the Fields pane, select Sales > Last Year Sales.

  2. From the Visualizations pane, select the icon for doughnut chart doughnut chart icon to convert your bar chart to a doughnut chart. If Last Year Sales is not in the Values area, drag it there.

    Visualization pane with doughnut selected

  3. Select Item > Category to add it to the Legend area.

    doughnut next to Fields pane

  4. Optionally, adjust the size and color of the chart's text.

Considerations and troubleshooting

  • The sum of the doughnut chart values must add up to 100%.
  • Too many categories make it difficult to read and interpret.
  • Doughnut charts are best used to compare a particular section to the whole, rather than comparing individual sections with each other.

Next steps

Funnel charts in Power BI

Visualization types in Power BI