Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
f_r_1998
Helper I
Helper I

Tooltip not working properly in waterfall chart

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: 

 

Screenshot 2024-10-08 164125.png

 

And here it does not appear: 

 

Screenshot 2024-10-08 164203.png

 

 

Thank you for your help!

1 ACCEPTED SOLUTION
v-linhuizh-msft
Community Support
Community Support

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:

vlinhuizhmsft_4-1728453415850.png

 

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.

vlinhuizhmsft_6-1728453520623.png

 

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

vlinhuizhmsft_3-1728440053229.png

 

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

vlinhuizhmsft_7-1728453672585.png

 

The result is as follows:

vlinhuizhmsft_0-1729647383242.png

 

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.

View solution in original post

1 REPLY 1
v-linhuizh-msft
Community Support
Community Support

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:

vlinhuizhmsft_4-1728453415850.png

 

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.

vlinhuizhmsft_6-1728453520623.png

 

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

vlinhuizhmsft_3-1728440053229.png

 

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

vlinhuizhmsft_7-1728453672585.png

 

The result is as follows:

vlinhuizhmsft_0-1729647383242.png

 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.