Troubleshoot charts in a paginated report (Report Builder)
Applies to: 
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
These issues can be helpful when working with charts in a paginated report.
Note
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Why does my chart count, not sum, the values on the value axis?
Most chart types require numeric values along the value axis, which is typically the y-axis, in order to draw correctly. If the data type of your value field is String, the chart cannot display a numeric value, even if there are numerals in the fields. Instead, the chart displays a count of the total number of rows that contain a value in that field. To avoid this behavior, make sure that the fields that you use for value series have numeric data types, as opposed to strings that contain formatted numbers.
Need more help?
Try:
- SQL Server Reporting Services on Stack Overflow
- Share ideas for SQL.