Filter Projects that are going on with a Year Slicer based on Start Date and End Date

[ericnz]

New to PowerBI. Thanks in advance. 

I am wokring on a report with powerbi to display the projects that's going on in each financial Year. I have a dataset like this:

and I try to create a dashboard like this, 

I hope I can use the year slicer to filter the projects that are going on, 

For example,  if I choose year 2026, project 1 should be included as well, because it covers. 

and I need the other charts to be interactive as well. 

Just wondering is there an easy way for this. 

Thank you. 

[amitchandak]

@ericnz , You can try like Current Employee Approch of HR

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[ericnz]

Hi Thank you so much for the quick response. That's really helpful. 

Just two more questions that might seem bit silly:

1.  so I would need to create a measure for each visual so that I can use one slicer to filter other visuals as well?

2.  For the matrix in the report, there aren't any calculations, just a display of the rows in original dataset. How to write the code for this?

Thank you.