Waterfall with multiple values

[PBIDev01]

Hello community,

is it possible in Power BI to create a Waterfall like this one? :

[v-moharafi-msft]

Hi @PBIDev01   ,

We wanted to check if your question has been resolved or if you are still facing any confusion feel free to reach out. Providing an update can be beneficial for others who might be experiencing similar challenges.

Thank you.

[HussamTheeb]

You can but you need some trickes 
Check this out:
https://youtu.be/jA-q1KQfdwg

[v-moharafi-msft]

Hi  @PBIDev01  ,

Thank you for reaching out to Microsoft Fabric Community and Thanks to @Ritaf1983   , @danextian  and @rohit1991   for Sharing valuable insights.

Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

 Best Regards,

Abdul Rafi.

[danextian · Accepted solution]

Hi @PBIDev01 

This is possible with the native stacked column chart but quite complex to setup.

Please see the attached pbix

[Ritaf1983]

Hi @PBIDev01 

Not exactly with the native Power BI Waterfall visual.

The built-in Waterfall visual supports one main value measure and a category axis. The Breakdown field can split the contribution by a dimension, but it does not create a true clustered / multi-series waterfall like the one in your screenshot.

If you need this exact layout, I would look at one of these options:
- reshape the data into a long format and test whether the Breakdown field is enough for your case;
- use a clustered column chart if the main goal is year-over-year monthly comparison;
- use a custom visual from AppSource;
- use Deneb / Vega-Lite for full control over the floating bars and multiple series.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[rohit1991]

Hii @PBIDev01 

Power BI’s native waterfall chart supports only a single measure and doesn’t allow multiple series comparison like the example. To achieve this, we either use a clustered column chart for comparison or switch to custom visuals like Zebra BI or xViz, which support multi-series waterfall scenarios.