We have been using the Waterfall Chart in Excel to present the changes in User Count in the month along the lines of:-
of users at start of month
- new users in the month
- renewed users in the month
- users due for renewal in the month
of users at end of the month
We want to be able to do the same in Power BI and noticed there is a similar Waterfall chart as well.
In our current Power BI model, line items #1 to #5 above are all Measures we’ve created in the model.
We understand that in order for Power BI Waterfall chart to work, the data table needs to be laid out as follows:-
Date / Factors / Value
“Date”" is the month of the year
“Factors” are the line items #1 to #5
“Value” is the respective corresponding value of #1 to #5
How do I create the waterfall chart table mentioned above in Power Bi?
Specifically, is it possible to create a measure (“Factors”) which is defined to be all the measures in #1 to #5 above?