Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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.
Regards,
Daniel He
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 🙂
Bumping this to see if anyone can assist 🙂
Hey, I'm running into a similar problem. Did you ever get this resolved?
Nope 😞
User | Count |
---|---|
78 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |