Sql Server Mobile Reports Pie Chart not summing negative values in the Total displayed in Donut

Fez 21 Reputation points
2021-02-23T21:31:07.94+00:00

Hi All,

Recently I have noticed that the Donut Pie chart in Mobile reports with the totals in the center is not properly summing up negative values
Surprisingly the pop-up on the pie chart is displaying the totals correctly
Also, A negative percentage is being displayed for negative amounts in the pop-up which does not make sense as the percentage should be absolute.
Is there a way to fix this? or just avoid it from displaying any percentage?

Thanks in advance for your support.

71238-piechart.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,079 questions
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.
2,849 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-02-24T06:54:03.663+00:00

    Hi @Fez ,
    I reproduced your issue which looks like a sum of absolute values. But pie charts are really not suitable for negative numbers, right? Pie charts are mainly used to describe the relative relationship between volume, frequency or percentage. For aggregation and display of positive and negative values, other forms of charts can be used.
    71426-01.jpg
    I suggest you submit the requirement at https://feedback.azure.com/forums/908035-sql-server.
    If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.
    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

1 additional answer

Sort by: Most helpful
  1. Fez 21 Reputation points
    2021-02-24T16:10:10.357+00:00

    Hi Joyzhao-MSFT,

    Thanks for your prompt response.
    I agree that Pie charts are rarely used for Negative numbers, and Bar charts are more preferred for this situation. But in Financial and Banking industry we have extensively used Pie charts in SSRS to display revenues with negative numbers.

    The main issue is the inconsistency between the totals displayed in the pop-up (when you click on the chart) and the totals displayed in the center of the donut.
    The total in the center of the donut chart sum's up the absolute values where as the Pop-up properly sum's up positive and negative values.
    I would consider it as a bug in the tool.

    Adding this feature to properly sum negative values in the center of the Donut Chart would be a huge plus for Mobile Reports as this would not impact other user's who always have absolute values. Other dashboard/reporting tools already have this feature available.

    I would definitely submit this requirement in the link you provided above.

    Thanks a lot for your help.