How to make chart of status of tasks in time?

[grofdaniela]

Hi, 

I have this issue with my report. I have tasks with 4 statuses and dates when they got into each one. (They can skip some of them) 

I need to make a stacked area chart which show me evolution of counts of these tasks. (in which time how manz was in status 1,2,

3 and 4 )

Thanks you so much for your help!

[kaushikd]

Hi @grofdaniela

I have taken your data as refference

What you have to do is to create 4 column with these Dax formulae.

#1 DayCount = DATEDIFF(TaskStatus[Status 1],IF(ISBLANK(TaskStatus[Status 2]),IF(ISBLANK(TaskStatus[Status 3]),IF(ISBLANK(TaskStatus[Status 4]),today(),TaskStatus[Status 4]),TaskStatus[Status 3]),TaskStatus[Status 2]),DAY)

#2 DayCount = IF(ISBLANK(TaskStatus[Status 2]),BLANK(),DATEDIFF(TaskStatus[Status 2],IF(ISBLANK(TaskStatus[Status 3]),TaskStatus[Status 4],TaskStatus[Status 3]),DAY))

#3 DayCount = IF(ISBLANK(TaskStatus[Status 3]),BLANK(),DATEDIFF(TaskStatus[Status 3],IF(ISBLANK(TaskStatus[Status 4]),TaskStatus[Status 3],TaskStatus[Status 4]),DAY))

#4 DayCount = IF(ISBLANK(TaskStatus[Status 4]),BLANK(),DATEDIFF(TaskStatus[Status 4],TaskStatus[Status 4],DAY))

Now your data will look like this

Now you can built your chart as i have done

Please mark this as a solution if this is what you needed...

[grofdaniela]

Thanks @kaushikd,

but I need time on X axis and need to see that for ex.  at May 6 i have 2 tasks in Status 1 (A, E), then at May 13 I have 2 (B, E) in Status 1 and 1 in Status 2 (A changed from status 1 to status 2).  

[Eric_Zhang · Accepted solution]

---

@grofdaniela wrote:

Thanks @kaushikd,

but I need time on X axis and need to see that for ex.  at May 6 i have 2 tasks in Status 1 (A, E), then at May 13 I have 2 (B, E) in Status 1 and 1 in Status 2 (A changed from status 1 to status 2).  

---

@grofdaniela

You need to unpivot your table and create a visual with the new table. See more details in the attached pbix file.

[grofdaniela]

Hi,

thank you very much, however, i solved this task few days ago by myself 🙂

[raorkim1]

him how did you fix this? 

was there an alternative method then previously advised by other members?

[raorkim1]

him how did you fix this? 

was there an alternative method then previously advised by other members?