Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Solved! Go to Solution.
Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@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 🙂
⭕ 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Done, thank you!
Highlight your project tasks visual and, on the Filter Panel for this visual, select Relative Date filter and enter next 14 days.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
A perfect solution! Thank you so much!
Bob
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |