Forum Discussion

PBILearner2022's avatar
PBILearner2022
Helper I
2 years ago

Waterfall Chart - set as total

Hi PBI  experts, We have a process wise data that needs to be converted as a waterfall chart as below ,Also we wanted to know the how it would be for next 2 years eg: if it is 2024 it should have th...
Need Help
Tips and Tricks
Tutorial Requests
PBILearner2022's avatar
PBILearner2022
Helper I
2 years ago

Anonymous Sorry to disturb you again were you able to check excel calculation that has been done? Is this is feasible in powerbi 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PBILearner2022 ,

 

We can indeed accomplish a similar effect in Power BI Desktop. In my first reply, I had the effect in Power BI Desktop. If you want to achieve the same effect as Excel, it seems unlikely at the moment.

 

Waterfall charts do meet your needs, and I think you can check out the documentation for further modifications: Waterfall charts in Power BI - Power BI | Microsoft Learn. As you can see in this document, the waterfall chart in Power BI Desktop has a hierarchical effect, so it looks like only the current effect is being achieved at the moment.

 

Best Regards,

Clara Gong

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