Timeline of process by aggregating days in process

[LParker97]

Hi 

I am hoping to create a visual where I can show the process over time by aggregating changes.

The data I have is.
- ID of object

- the category it is currently in

- The days spent in this category

- Total days since start.

- date of change

The idea for the visual is to see the ration of cases over time. so for each day it is split by the number of cases. I need a bit of help as I am unsure how to do this within powerBI, I was thinking somehow using the stacked area chart to represent the proportions.

Thanks

[amitchandak]

@LParker97 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

The visual seems like a table or Matrix, treemap

[LParker97]

I cannot share the actial data but below is some sample data of a similar structure in powerBI

ID	category	Status change	Next status change	datediff
1	not started	01/05/2020	03/05/2020	2
1	check	03/05/2020	17/05/2020	14
1	repair	17/05/2020	05/06/2020	19
1	clean	05/06/2020	18/06/2020	13
1	bill	18/06/2020	08/09/2020	82
2	not started	02/05/2020	13/06/2020	42
2	check	13/06/2020	17/06/2020	4
2	repair	17/06/2020	25/06/2020	8
2	clean	25/06/2020	26/06/2020	1
2	invoice	26/06/2020	14/08/2020	49
2	bill	14/08/2020	08/09/2020	25
3	not started	05/05/2020	08/05/2020	3
3	check	08/05/2020	14/05/2020	6
3	repair	14/05/2020	20/05/2020	6
3	clean	20/05/2020	13/06/2020	24
3	bill	13/06/2020	08/09/2020	87
4	not started	04/04/2020	03/07/2020	90
4	check	03/07/2020	06/07/2020	3
4	repair	06/07/2020	16/07/2020	10
4	clean	16/07/2020	08/08/2020	23
4	invoice	08/08/2020	10/08/2020	2
4	bill	10/08/2020	08/09/2020	29

I sort of want a chart like the following below:

[v-jayw-msft]

Hi @LParker97 ,

Are you want the timeline for the percentage of each status?

Best Regards,

Jay