Skip to main content

Power BI

Needs Votes

Waterfall Chart - Custom Start/End Points

Vote (44) Share
Ryan Premak's profile image

Ryan Premak on 17 Jul 2018 22:48:54

It would be great if the standard waterfall visualization could have a customized start value. For example, a waterfall chart that we typically use is Actual Revenues variance to Forecast. It would be great if the starting point of the waterfall could be Forecasted revenues, and the ending point could be Actual Revenues. Currently, the only option is the visualization starts at $0 and ends at the variance.

Comments (2)
Ryan Premak's profile image Profile Picture

kendrick on 06 Jul 2020 00:00:24

RE: Waterfall Chart - Custom Start/End Points

The ability to set dynamic starting values (actuals or budget) is essential for financial reporting. The vanilla waterfall lacks context and is rather unhelpful in communicating the desired narrative to ones audience for a BI tool.

Please bring the power BI waterfall visual in line with its excel counterpart.

Ryan Premak's profile image Profile Picture

Kevin on 05 Jul 2020 23:49:21

RE: Waterfall Chart - Custom Start/End Points

Hey Ryan. I've found some tricks for achieving this. Only problem is you can't get the starting point to be the same color as total. Check out my idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37721728-waterfall-conditional-colors-starting-point