How to add total for all years as a last column in bar chart?

[Anonymous]

Thanks!

[v-piga-msft]

Hi @Anonymous ,

It seems that you want have a grand total like that in Matrix. 

However, I'm afraid that we cannot have a total value like that in bar chart.

You could try the workaround that create a measure for total and then create the line and clustered column chart like below. 

Best Regards,

Cherry

[Anonymous]

Can we do add a line chart on it to make cumulated value?

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample so that we could help further on it.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

Sorry for the delay.

Yes, you could create a measure to calculate the cumulated value and use line and clustered column chart to achieve that.

Best Regards,

Cherry