SSRS Doughnut Chart

This SSRS article shows how to create an Exploded Donut or Doughnut chart, Show Data Labels, and format fonts and colors with an example. To demonstrate this example, right-click on the Datasets folder to create a new DataSet. 

The below screenshot shows the data set that we use for this SSRS Doughnut or Dount Chart example.


The Sql query that we used above SSRS example is:

SELECT Cat.[EnglishProductCategoryName] AS Category,   
       SUM(Fact.OrderQuantity) AS Orders, 
       SUM(Fact.SalesAmount) AS Sales 
FROM FactInternetSales AS Fact
   INNER JOIN DimProduct AS Prod ON Fact.ProductKey = Prod.ProductKey
   INNER JOIN DimProductSubcategory AS SubCat ON Prod.ProductSubcategoryKey = SubCat.ProductSubcategoryKey 
   INNER JOIN DimProductCategory AS Cat ON SubCat.ProductCategoryKey = Cat.ProductCategoryKey
GROUP BY Cat.[EnglishProductCategoryName]

SSRS Donut or Doughnut Chart

To add a Doughnut chart, right-click the report area, choose Insert, and then the chart option from the context menu. Otherwise, drag and drop the chart from the toolbox to the report area.

Insert a Chart

Select the Donut Chart from the window and click OK to add to the report area.

Select SSRS Donut or Doughnut Chart

Use Plus button or drag the fields to the Values and Category Groups section.

Add Columns to Values and Category Groups

Here, we added the Orders column to the Values and Product category to the Category Groups section. Next, right-click on the donut chart and select the Show Data Labels option to add labels.

Show data labels in SSRS Donut or Doughnut Chart

Right-click the Data Labels and select the Series Label Properties option to format the Numbers.

Format Data label Numbers

Use the toolbar or properties window to format the doughnut chart font, X and Y-axis color, data labels, and legend.

Format Fonts and Colors

Click the preview button to see the SSRS Doughnut chart.

SSRS Donut or Doughnut Chart Preview

Right-click on the chart and choose the Change Chart Type option. 

Change Chart Type option

Next, select the SSRS Exploded Doughnut Chart from the window.

Choose Exploded Donut

And the final Exploded Doughnut Chart is.

SSRS Donut or Doughnut Chart Design Mode

Preview the report.

SSRS Exploded Donut or Doughnut Chart Preview