Filter activities in a period

[PhilJuniper]

I have a table, simplified as

• Task Name
• Task Start Date
• Task Finish Date

I wish to be able to filter tasks that are active in a specified period, selected via two slicers (Period Start and Period End)

So the table when filtered would show tasks where:-

• Task start is equal to or less than period end
• AND
• Task finish is equal to or greater than period start

How can i do this please?

[PhilJuniper]

@v-xiaotang Can you take a look at my question in post #3 and #4 please?

[PhilJuniper]

E.g. in the following example, i would want one slicer to select the period start, another to select the period end, and the result would be the table showing the green tasks.

[v-xiaotang]

Hi @PhilJuniper 

Thanks for reaching out to us.

I suggest you use a slicer to get the date range, and if you want to use two slicers, you have to create two date tables.

(1) create the calendar table

(2) create the measure,

filtermeasure = 
var _start=MINX(ALLSELECTED(CALNEDAR),[Date])
var _end= MAXX(ALLSELECTED(CALNEDAR),[Date])
return IF(MIN('Table'[Task Start Date])>=_start && MIN('Table'[Task Finish Date]) <=_end,1,0)

then put it into visual-level filter of your visual, set it to 1

result

Best Regards,

Community Support Team _Tang

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

[PhilJuniper]

Thanks for that. How do I define the period start date and period end date that i want to use? Note these are different to the task start and end dates.

So i want to define two dates, period start and period end.

I want the tasks to be filtered according to these period dates. E.g. in your table, if i chose period start 11th Feb, period end 11th March, i would then just see tasks D and E.