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
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!
Solved! Go to 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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
106 | |
93 | |
69 |
User | Count |
---|---|
167 | |
132 | |
130 | |
96 | |
91 |