Forum Discussion
Waterfall visual: add additional disconnected bart
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 PowerToBI ,
I see what’s happening—the Waterfall visual is treating "Start" and "End" as just another addition rather than a calculation of the previous steps.
To get "Start" to align at the same level as "Intro" and have "End" act as the final sum, you don't actually need a more complex measure; you just need to use a specific formatting feature in Power BI.
Try this:
- Select your Waterfall chart.
- Go to the Format Pane (the paintbrush icon).
- Expand the Columns (or Pillars) section.
- You will see a list of your Labels (Intro, A, B, C, Start, End).
- Find "Start" and "End" in that list and toggle the switch to "Set as total."
Why this works:
When you "Set as total," Power BI stops treating that category as a "floating" bar and anchors it to the bottom of the Y-axis. This will make your "Start" pillar look exactly like your "Intro" pillar, and your "End" pillar will represent the final result of the whole sequence.
If "Start" is meant to be a subtotal of everything before it, this formatting change is the most reliable way to fix the visual without breaking your DAX.
Let me know if those bars anchor correctly for you!