Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ericnz
Frequent Visitor

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

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:

 

Capture.PNG

 

and I try to create a dashboard like this, 

 

Capture.PNG

 

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. 

 

 

2 REPLIES 2

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.