Show or hide total values on a chart
1. Overview
This article explains how to show or hide data points representing total values on a chart.
2. Show total values
For this example, set up a chart to display OrderQty by OrderDate.
By default, the chart uses a Date/Time axis, but this won't work with total values. Go to the toolbar and change it to Category Axis which will give you expanders along the X-axis.
Go to the chart Properties and in the Main tab, under Options, uncheck the Hide Total Values property which applies to chart types other than Pie. When this property is unchecked, grand totals and subtotals are displayed in the chart.
Specifically, you'll see an (All) data bar added to the chart above which represents the sum of the other data bars. In the Data Preview, the Grand Total value in the table visualization corresponds to this newly added data bar.
Next, open the Data Analysis Panel for the bar chart and drag the Product hierarchy to the COLUMNS field. This will generate a chart series for each Product value plus an additional series which displays the grand total for each row or data point. Also, the (All) value turns into a cluster of total values, each representing the grand total for a specific Product.
Comparison of values in the above chart may be difficult because the total values are so much larger than the rest. You can improve the situation by hiding the total that is displayed at each cluster. To do this, open the Data Analysis Panel for the bar chart and click the Edit button at the top. In the Metric Set Configuration dialog, set Shown Totals to Rows.
The overall total value and the grand total for each row (data point) are not displayed anymore, only the grand total for each Product. This makes it easier to compare values in the chart.
3. Show grand total for a pie chart
Pie charts are handled a bit differently because they already display total values other than grand totals.
For a pie chart, uncheck its Hide Grand Total property in order see the grand total value which is displayed at the center of the chart.
