Forum Discussion
Waterfall charts with start and endvalues
Hello everyone,
I am trying to build a waterfall diagram in Power BI, to illustrate the Budget variance across departments for example.
Right now I can only illustrate the "variance difference" but I would like to show the start-values an end values as columns in the waterfall, in this case "Finance Budget" as a start value and "Finance Acutals" as end-value.
| Finance Budget | 18.111 | Startvalue |
| Department 1 | 2.938 | Variance |
| Department 2 | -406 | Variance |
| Department 3 | -665 | Variance |
| Department 4 | -2.876 | Variance |
| Finance Actual | 17.102 | Endvalue |
I hope someone can help.
Søren
Hi Søren,
The waterfall visualization provided by power bi currently does not provide this function.
As a workaround, I suggest you create an index column on the data model:
and then sort the columns you want to put on the category according to this index:
If you don't want to show the last total column, please try to use the custom visual:https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001336?tab=Overview
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
1 Reply
v-deddai1-msftCommunity Support
Hi Søren,
The waterfall visualization provided by power bi currently does not provide this function.
As a workaround, I suggest you create an index column on the data model:
and then sort the columns you want to put on the category according to this index:
If you don't want to show the last total column, please try to use the custom visual:https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001336?tab=Overview
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai