Visual to show when date is between a list of other dates

[Anonymous]

Hi!

I have a list projects with respective milestones and I want to check between which milestones the projects were cancelled.

Example of data:

ID	Milestone A	Milestone B	Milestone C	Cancelled
1	1/1/2019	2/1/2019	3/1/2019	1/15/2019
2	2/1/2019	3/1/2019	4/1/2019	3/15/2019
3	3/1/2019	4/1/2019	5/1/2019	4/15/2019
4	4/1/2019	5/1/2019	6/1/2109	5/15/2019

I want to create a visual (histogram-esque) to show between which milestones the cancellation dates are falling.

Recommendations and help appreciated!

[v-shex-msft]

Hi @Anonymous ,

I'd like to suggest you use unpivot column feature to convert these milestone fields to attribute and value, then you simple create visual to analyze all milestone type and corresponding date ranges.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng

[Anonymous]

@v-shex-msftthanks for the feedback but this isn't what I am looking for. I do not care about the dates themselves. It is more about how the milestones relate relatively to one another.

[v-shex-msft]

Hi @Anonymous ,

Unpivot column function will convert all milestone fields to attribute and value. You can write a measure to calculate between milestone based on current id group and canceled date.

Regards,

Xiaoxin Sheng