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 , alish_b
Of course some here are the tables from my example.
In general and some more context. For the category Intro I want to display kpi FY 2024, for category Start YTD 2024 (Jan-Oct) and for End YTD 2025 (Jan-Oct) shall be displayed. The kpis I do know how to calculate.
The date table is filtering the fact table
1. CategoryTable
| Category |
| Intro |
| Start |
| End |
2.breakdownTable
| Breakdown |
| A |
| B |
| C |
3.FactTable
| Date | Breakdown | Amount |
| 01.01.2024 | A | 100 |
| 01.02.2024 | A | 120 |
| 01.03.2024 | B | 150 |
| 01.04.2024 | C | 130 |
| 01.05.2024 | A | 140 |
| 01.06.2024 | B | 160 |
| 01.07.2024 | C | 170 |
| 01.08.2024 | A | 180 |
| 01.09.2024 | B | 190 |
| 01.10.2024 | C | 200 |
| 01.11.2024 | A | 210 |
| 01.12.2024 | B | 220 |
| 01.01.2025 | A | 200 |
| 01.02.2025 | B | 210 |
| 01.03.2025 | C | 220 |
| 01.04.2025 | A | 230 |
| 01.05.2025 | B | 240 |
| 01.06.2025 | C | 250 |
| 01.07.2025 | A | 260 |
| 01.08.2025 | B | 270 |
| 01.09.2025 | C | 280 |
| 01.10.2025 | A | 290 |
4.date table
| Date | Year | Month |
| 01.01.2024 | 2024 | 1 |
| 02.01.2024 | 2024 | 1 |
| 02.01.2024 | 2024 | 1 |
| 03.01.2024 | 2024 | 1 |
| 03.01.2024 | 2024 | 1 |
| 04.01.2024 | 2024 | 1 |
| ... | .... | ... |
| 01.10.2025 | 2025 | 10 |