Forum Discussion
Waterfall visual: add additional disconnected bart
- 7 months ago
Hi PowerToBI ,
In the standard Power BI waterfall chart, the running baseline is fixed and continuous across the entire visual.
The chart does not support restarting or resetting the baseline at an intermediate category. A baseline reset is only possible when using the automatic final Total column, or splitting the logic across separate visuals. Because of this built-in behavior, two categories cannot independently start from the same baseline within a single standard waterfall.
Consequently, a configuration where multiple categories e.g. Intro and Start independently originate from the same baseline cannot be achieved within a single instance of the standard Power BI waterfall visual.
Hope this helps.
Thank you.
Hi FBergamaschi ,hi alish_b
of course. I hope this helps. otherwise I adjust.
KPI detail
In the very end: Intro shall show the value for full year 2024. Start should display YTD 2024 and End should display YTD 2025. The calculation of full year and YTD figures are not an issue.
Tables
The example tables are as follows:
1. CategoryTable
| Category | Index |
| Intro | 0 |
| Start | 1 |
| End | 2 |
2. BreakdownTable
| Breakdown |
| A |
| B |
| C |
3. FactTable
| Date | Breakdown | Amount |
| Monday, January 1, 2024 | A | 100 |
| Thursday, February 1, 2024 | A | 120 |
| Friday, March 1, 2024 | B | 150 |
| Monday, April 1, 2024 | C | 130 |
| Wednesday, May 1, 2024 | A | 140 |
| Saturday, June 1, 2024 | B | 160 |
| Monday, July 1, 2024 | C | 170 |
| Thursday, August 1, 2024 | A | 180 |
| Sunday, September 1, 2024 | B | 190 |
| Tuesday, October 1, 2024 | C | 200 |
| Friday, November 1, 2024 | A | 210 |
| Sunday, December 1, 2024 | B | 220 |
| Wednesday, January 1, 2025 | A | 200 |
| Saturday, February 1, 2025 | B | 210 |
| Saturday, March 1, 2025 | C | 220 |
| Tuesday, April 1, 2025 | A | 230 |
| Thursday, May 1, 2025 | B | 240 |
| Sunday, June 1, 2025 | C | 250 |
| Tuesday, July 1, 2025 | A | 260 |
| Friday, August 1, 2025 | B | 270 |
| Monday, September 1, 2025 | C | 280 |
| Wednesday, October 1, 2025 | A | 290 |
4. DateTable
| Date | Year | Month |
| Monday, January 1, 2024 | 2024 | 1 |
| Tuesday, January 2, 2024 | 2024 | 1 |
| Tuesday, January 2, 2024 | 2024 | 1 |
| Wednesday, January 3, 2024 | 2024 | 1 |
| Wednesday, January 3, 2024 | 2024 | 1 |
| Thursday, January 4, 2024 | 2024 | 1 |
| Thursday, January 4, 2024 | 2024 | 1 |
| ... | ... | ... |
| Wednesday, October 1, 2025 | 2025 | 1 |