cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
grofdaniela Frequent Visitor
Frequent Visitor

How to make chart of status of tasks in time?

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) Capture.jpg

 

 

 

 

 

 

 

 

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: How to make chart of status of tasks in time?


@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.

 

Capture.PNG

 

Capture.PNG

6 REPLIES 6
kaushikd Member
Member

Re: How to make chart of status of tasks in time?

Hi @grofdaniela

I have taken your data as refference

Capture.PNG

 

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

Capture.PNG

 

Now you can built your chart as i have done

Capture.PNG

 

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

grofdaniela Frequent Visitor
Frequent Visitor

Re: How to make chart of status of tasks in time?

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).  

 

 

Moderator Eric_Zhang
Moderator

Re: How to make chart of status of tasks in time?


@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.

 

Capture.PNG

 

Capture.PNG

grofdaniela Frequent Visitor
Frequent Visitor

Re: How to make chart of status of tasks in time?

Hi,

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

raorkim1 Frequent Visitor
Frequent Visitor

Re: How to make chart of status of tasks in time?

him how did you fix this? 

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

raorkim1 Frequent Visitor
Frequent Visitor

Re: How to make chart of status of tasks in time?

him how did you fix this? 

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