Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
Do you know if it is possible to sort on the years in a Gantt chart in Power Bi?
I have a lot of different task with a start and end date. The visual is "on years" I would like for example to just show the tasks that are ongoing during 2025-2026 regardless of start and end date. I have tried to filter on start and end date but then I dont get all tasks that are ongoing a certain period. I wonder if it is possible to show all tasks that are ongoing during 2025 for example regardless of end and start date. It could start 2022 or 2025 and last during 2025 or longer....
Solved! Go to Solution.
Hi @A_Rosell
You need to add a disconnected Date table for the filter/slicer, then create a measure to tell whether a task is ongoing during a selected period. Use this measure as a filter on the Gantt chart to show the ongoing tasks. I have attached a sample pbix at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @A_Rosell
You need to add a disconnected Date table for the filter/slicer, then create a measure to tell whether a task is ongoing during a selected period. Use this measure as a filter on the Gantt chart to show the ongoing tasks. I have attached a sample pbix at bottom.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |