Forum Discussion
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
Data Model: 'Projects'[Id] ----> 'Project Tasks'[ProjectId]
Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.
Regards,
Pat
A perfect solution! Thank you so much!
Bob
6 Replies
Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.
Regards,
Pat
A perfect solution! Thank you so much!
Bob
bob57
Create a measure and assign it to the visual as 1You 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 🙂
A fine alternate solution. Thank you very much!
Bob
