Tooltip not working properly in waterfall chart

[f_r_1998]

Hello everyone,

I created a waterfall chart that shows the %growth in sales and I added the absolute growth as a tooltip. The tooltip appears for all bars except for the Total (dark blue). I tried to put different measures into the tooltip to see whether it has something to do with the absolute growth measure but for none it is working. I couldnt find any option to activate it on the right panel where you format the visualization. Does someone know why and how to fix this? 

As you can see, here the absolut growth apears in the tooltip: 

And here it does not appear: 

Thank you for your help!

[Anonymous · Accepted solution]

Hi @f_r_1998 ,

According to my tests, the situation is as you say.  Here is an alternative way to manually add a total column that will achieve the type of effect, you can refer to it for your own needs.

This is my test data:

1.Create a new table:

NewTable = 
UNION(
    'Table',
    ROW(
        "Month", "Total",
        "Sales",SUM('Table'[Sales]),
        "Growth Percentage", SUM('Table'[Growth Percentage]),
        "rate", SUM('Table'[rate]),
        "index",MAX('Table'[Index])+1
    )
)

2.Set Month column to be sorted by index.

3.Create a new waterfall chart using fields from the new table and do not show total column. 

4. Change the sorting of the chat and an approximation can be obtained:

The result is as follows:

Best Regards,
Zhu

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