Filter and display on going or active tasks

[eatcake4dinner]

I am new to PowerBI and am using a custom visual Play Axis. I have two tables: Date and TaskTable.

I was able to create a calendar in Date table using plannedStart and plannedFinish dates from the TaskTable. 

Now I'd like to display the tasks that are actively being filtered Play Axis date.

This filter will filter all tasks with planned start >= the date in Play Axis, or with planned finish <= the date in Play Axis. 

Here is what my data looks like.

Would you please provide some suggestions?

Thanks, 

Cake

[eatcake4dinner · Accepted solution]

I used the method from this post and it seems to be working. https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

[dax]

Hi @eatcake4dinner ,

It seems that you solve the problem , right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Best Regards,
Zoe Zhi

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