Workload by time

[tunahankucuker]

Hello everyone,

I am sharing the data and the corresponding visualization for the "Open Tasks by Month and Their Workload" chart, which is one of our requirements.

In this visualization, the X-axis represents the period, and the totals are stacked based on createPeriod. The colors are differentiated by quarters.       

For example, when we look at the period May-2024, we can see that 17 tasks remained open since March-2023.

The color coding is consistent for the quarter containing April, May, and June.

How can we implement this setup in Power BI?

Thank you in advance for your help!

[tunahankucuker]

Our company recently transitioned from another business intelligence program to Power BI. Therefore, I need to share it this way. I'm sorry for any inconvenience.

our data like this:         

period	issuetype	severity	importance	source	createPeriod	count
3/1/2023	Defect	Major	NULL	Employee	3/1/2023	2
3/1/2023	Defect	Minor	NULL	Employee	3/1/2023	4
3/1/2023	Requirement Change	NULL	Medium	Customer	3/1/2023	9
3/1/2023	Requirement Change	Major	Medium	Customer	3/1/2023	3

[hackcrr · Accepted solution]

Hi, @tunahankucuker 

First, you need to create a metric to calculate the cumulative number of uncompleted tasks:

CumulativeOpenTasks = 
CALCULATE(
    SUM('YourTable'[count]),
    FILTER(
        ALL('YourTable'),
        'YourTable'[period] <= MAX('YourTable'[period])
    )
)

Create a calculated column to differentiate tasks based on their creation duration:

OpenTasksByCreationPeriod = 
CALCULATE(
    SUM('YourTable'[count]),
    FILTER(
        'YourTable',
        'YourTable'[createPeriod] = EARLIER('YourTable'[createPeriod])
    )
)

In Power BI Desktop, add a new stacked area map to the report. Drag this PERIOD field to the X-axis. Drag the CumulativeOpenTasks metric to the Value field. Drag the field createPeriod to the legend to differentiate tasks based on when they were created. In the Format pane, set the color coding for each quarter. This can be achieved by assigning a specific color to each value in the field createPeriod.

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly