Dear community,
I am building a dashboard for my team to summarize our work intake and output. We manage our tasks in a backlog in a SharePoint list. Each entry (work item) consists of multiple fields such as Name, Description, Entry Date, Close Date, etc...
I'm trying to create a single visual that shows a "burndown" of how many entries are created and how many are completed for each month. But so far I have only been able to this by creating 2 separate visuals - one, where the x-axis is based on the entry date, and one where the x-axis is based on the closed date. See below:
Here's some sample data that can be used for the visual:
Work ItemEntry DateClose Date
|
Could you help me figure out how I can create a visual with both data point that show: Entered and closed items each month, where closed items were created that month AND were created in a month prior. Based on the sample data, the visual should show:
June 2023: 1 created
September 2023: 1 created
November 2023: 1 created
January 2024: 4 created
February 2024: 14 created, 2 closed
March 2024: 21 created, 24 closed
April 2024: 36 created, 27 closed
May 2024: 12 created, 33 closed
June 2024: 8 created, 10 closed
July 2024: 2 created, 4 closed
Thank you in advance.
Hi,@Hammerjunge I am glad to help you.
Hello,@lbendlin. thanks for your concern about this issue.
Your answer is excellent! And I would like to share some additional solutions below.
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions
If your requirements have not yet been realized, I have performed the relevant tests based on the data you have since provided, which I hope will be helpful to you.
According to your description, you want to see how many work items are opened and closed per month.
Here is my test
M_EntryNum =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALL ( 'Table' ),
'Table'[Entry Date] >= MIN ( 'Calendar_'[Date] )
&& 'Table'[Entry Date] <= MAX ( 'Calendar_'[Date] )
)
)M_CloseNum =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALL ( 'Table' ),
'Table'[Close Date] >= MIN ( 'Calendar_'[Date] )
&& 'Table'[Close Date] <= MAX ( 'Calendar_'[Date] )
)
)Here is the test data:
Calendar_ = CALENDARAUTO()
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@Hammerjunge I am glad to help you.
Hello,@lbendlin. thanks for your concern about this issue.
Your answer is excellent! And I would like to share some additional solutions below.
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions
If your requirements have not yet been realized, I have performed the relevant tests based on the data you have since provided, which I hope will be helpful to you.
According to your description, you want to see how many work items are opened and closed per month.
Here is my test
M_EntryNum =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALL ( 'Table' ),
'Table'[Entry Date] >= MIN ( 'Calendar_'[Date] )
&& 'Table'[Entry Date] <= MAX ( 'Calendar_'[Date] )
)
)M_CloseNum =
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALL ( 'Table' ),
'Table'[Close Date] >= MIN ( 'Calendar_'[Date] )
&& 'Table'[Close Date] <= MAX ( 'Calendar_'[Date] )
)
)Here is the test data:
Calendar_ = CALENDARAUTO()I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
