SSRS report - gauge that looks like donut

mark goldin 696 Reputation points
2021-07-17T22:41:17.413+00:00

I need to create a gauge that looks like this:

115566-image.png

Any idea how to add actual data to it? I have one row with 4 columns with numeric values. I want it act as a donut chart but wuth text in the center.

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,067 questions
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,636 Reputation points
    2021-07-19T07:04:12.613+00:00

    Hi @mark goldin ,
    I did some test. If you need to add a total label to the doughnut, you need to create a Gauge instead of a Doughnut chart. Because Doughnut does not support adding a text box in the middle of the chart.
    Below is the donut I created using Gauge.
    115793-01.jpg

    • At first create Gauge, as shown below.
      115779-02.jpg
    • Delete all data, leaving only the Textbox in the middle. Then select "Radial Scale "Properties" and set "Sweer angel (degrees)" to 360 degrees. And set the color to "No color" in the "Fill" option.
      115780-03.jpg
      115813-06.jpg
      115832-07.jpg
    • Add Range——Range Properties. Change the general options and fill in the options as shown below. Here "Start range at scale values" to "End range at scale value" are "1-35", you can adjust according to your data scale. The default value is 0-100.If you mind borders, you could set the border to "None".
      115750-04.jpg
      115720-05.jpg
    • Add Range again,follow the previous steps to modify the attributes and colors. Modify "Start range at scale values" to "End range at scale value" to "35-60", and change the Fill option to other colors. And so on, until it becomes a complete donut.
      • Modify the text box in the middle of the donut.

    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.