How to show Total Amount at the end in Stacked Column Chart

[Anonymous]

Hello,

I have added Stacked column chart in which it is showing data of A, B, C and its amount.

I have graph like this:

I want result like following graph which shows Total(A+B+C) at the end of the chart:

Thanks.

[Anonymous]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01 · Accepted solution]

@Anonymous 

the axis must present in the dataset itself

You need a table like this

| name  | amount | Column |
|-------|--------|--------|
| A     | 4000   |        |
| B     | 5500   |        |
| C     | 6000   |        |
| Total |        |        |

You need a measure like this

_total = 
VAR _currentlyVisiblePlace =
    MAX ( fct[name] )
VAR _aggregation =
    SWITCH (
        TRUE (),
        _currentlyVisiblePlace <> "Total", SUMX ('fct',fct[amount] ),
        _currentlyVisiblePlace = "Total", SUMX ( ALL ( fct ),fct[amount])

    )
RETURN
    _aggregation

[AlexisOlson]

You can do this with a column chart but it will be significantly simpler with a waterfall chart since you get the total automatically.

Note: I'm not saying you need to do this way, just pointing out another possibility.

[Anonymous]

Hi @AlexisOlson ,

Thanks for your quick response. I tried this way as well. but client need result in stacked column chart only.

[AlexisOlson]

OK. In that case, see if these prior posts help.

https://community.powerbi.com/t5/Desktop/Grand-Total-in-Bar-Chart/m-p/612631

https://community.powerbi.com/t5/Desktop/How-to-get-a-quot-Total-column-quot-in-the-clustered-column...