Watefall charts and formating data

Question

Hello everyone,I have a very simple data table that is made of 4 columns (with examples):1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4Event&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date of beginning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date of ending&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; statusEvent 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/02/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;closedEvent 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15/08/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;openEvent 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04/10/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/12/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cancelled...&nbsp;One or more events may be added every day/few days.&nbsp;My goal is to make a waterfall chart that would show how many are active every given month, and understand&nbsp; the movements (+1 for newly opened and -1 for closed).I am having trouble using the waterfall chart or finding the idea on how to format my data in order for it to be usable for the waterfall chart.Any help would be greatly appreciated.Regards,A

anonymous · Accepted Answer

Hi&nbsp;Zalexatwork,
It seems like a common multiple date fields analysis requirements, you can refer to the following link start date, end date parts if help:
Before You Post, Read This&nbsp;
In addition, you can also try to create a bridge table to expand all the detail records in the date ranges and mapping with raw table records:Solved: Spread revenue across period based on start and en... - Microsoft Power BI CommunityRegards,
Xiaoxin Sheng

Forum Discussion

Watefall charts and formating data

1 Reply

Related content

Chart Formatting

3D Format Column Chart

Bar Chart Conditional Formatting

Legend Format for Line Column Chart

Conditional formatting on stacked column chart