Create cumulative flow diagram (stacked area)

[Anonymous]

Trying to create a cumulative flow diagram in Power BI. I have the InProgressDate as well as the CompletedDate. As well as this I also have a date calendar like so:

  

I'm trying to create a chart like so, but unsure of what measures and/or columns needs to be introduced

Any ideas?

[v-danhe-msft]

Hi @Anonymous,

From your description, I could not figure out any data about the [Number of items] column post in your picture, could you please offer me more information about your data structure or share your pbix file if possible? And I have entered some sample data to show the picture, you could refer to it.

1.Sample data structure.

2.Create a Stacked area chart and add the related column, you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/1pfzb03at4iu8bk/Create%20cumulative%20flow%20diagram%20%28stacked%20area%29.pbix?dl=0

Regards,

Daniel He

[Anonymous]

Hi Daniel,

Thanks for your reply.

So what I'm trying to figure out is what measure/formula I need to add to calculate the cumulative number of items in progress on a given date and the cumulate number of items completed on a given date, based on the InProgressDate and CompletedDate.

So, essentially I'm trying to understand what I need to do in order to get my data into the format you have it in 🙂

[Anonymous]

Bumping this to see if anyone can assist 🙂

[dean_rowntree]

Hey, I'm running into a similar problem. Did you ever get this resolved?

[Anonymous]

Nope 😞