Show Grand Total label on a stacked column chart

0
votes

I have a Line and Stacked Column chart to which I want to add a "Grand Total" label at the top as the sum of the components in the stack.

I'd like to create a measure that sums the values in the Total column (in the data shown at the bottom of the screenshot) as "Grand Total" so that it can be applied to the chart. I've had no luck using the SUM and SUMMARIZE functions so far.

Suggestions to achieve this are much appreciated. Thanks in advance.

Line and Stacked Column Chart

Detail data with Grand Total Measure on column CapExOpExNew[Total]

enter image description here

1
powerbidax

1 Answers

0
votes

There's not a built-in way to do this at the moment but there are workarounds.

The idea is to use the combo Line and Stacked Column Chart and put the total as the line value and then hide the line.

Radacad explains it in more detail here:

Showing the Total Value in Stacked Column Chart in Power BI

To get a grand total across all of the divisions, you can adjust your filter context as follows:

GrandTotal =
CALCULATE ( SUM ( CapExOpExNew[Total] ), ALL ( CapExOpExNew[Funding Division] ) )