Forum Discussion
waterfall chart with delta-ready inputs
Dear All,
I would like to reproduce in POWER BI the following waterfall chart, starting from the same table as i have in excel
take into account that in excel there is a very easy and quick way of assigning the column (in green) as Total, so that the waterall can especially end up to the final result, without summing up the last amount.
thanks a lot
Hi mircogia ,
You need to import this table without "NPV POST" column because PowerBI will calculate the total value automatically.
Then unpivot this table in the query editor.
Now you can use it to make a waterfall chart visual.
Here is my test file and you can refer to it.
3 Replies
- v-eachen-msft
Community Support
Hi mircogia ,
You need to import this table without "NPV POST" column because PowerBI will calculate the total value automatically.
Then unpivot this table in the query editor.
Now you can use it to make a waterfall chart visual.
Here is my test file and you can refer to it.
very clear, thanks!
another question: now imagine i have not just CASE A, but also CASE B, C and so on ,with also a TOTAL which simply sum up the single cases. How could set up the excel in order than to be able to filter in POWER BI (with a slicer for example) to show either a single case result or the TOTAL?
thanks in advance
Mirco
- v-eachen-msft
Hi mircogia ,
I don't think there is a way to do it. Slicer and fliter are the solutions you can choose.
