Waterfall chart bar is not showing ending value correctly

[dokat]

Hi,

I created a waterfall chart (see below). however bar thats showing ending value is not showing correctly. It is showing totals above the last bar rather than horizontal axis. Did anyone come across same issue and help me solve the problem?

here is the formula i am using 

Revenue by PVM = SWITCH(MAX(Tree[ID]),
    1, SUM('StaPVM'[Dollar LY]),
    2, [Value],
    3, [Volume],
    4, [Price],
    5, [Promo],
    6, [Mix],
    7, SUM('StaPVM'[Dollar TY])

[v-chenwuz-msft · Accepted solution]

Hi @dokat ,

Did you enable the Show total function under Y-axis?

The reault:

Best Regards

Community Support Team _ chenwu zhu

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