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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
bob57
Helper IV
Helper IV

Filtering based on date range.

Good day!

This seems pretty simple, but the solution escapes me. As currently designed, I can click on a project in the 'Top Level Project View' table and all tasks for that project will appear in the 'Task Starts foe Next 14 Days' table. I only want to see tasks that will start over the next 14 days. Here is a ink to the .pbix, if helpful: https://1drv.ms/u/s!Agkx6hQs0NiX1jVhOSd6FFATlSP3?e=SLnAJt.

Thank you for your time and effort.

Bob

bob57_0-1604167754130.png

Data Model: 'Projects'[Id] ----> 'Project Tasks'[ProjectId]

bob57_1-1604168532045.png

 

2 ACCEPTED SOLUTIONS
mahoneypat
Microsoft Employee
Microsoft Employee

Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.

mahoneypat_0-1604171913058.png

 

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

A perfect solution! Thank you so much!

Bob

View solution in original post

6 REPLIES 6
Fowmy
Super User
Super User

@bob57 

Create a measure and assign it to the visual as 1

You can download the file: HERE

Next14Days = 

IF( SELECTEDVALUE('Project Tasks'[StartDate]) > (TODAY() + 14) , 0 , 1 )

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

A fine alternate solution. Thank you very much!

Bob

@bob57 

Glad it worked, you can accept more than one solution.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Done, thank you!

mahoneypat
Microsoft Employee
Microsoft Employee

Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.

mahoneypat_0-1604171913058.png

 

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


A perfect solution! Thank you so much!

Bob

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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