Gantt chart, possibility to sort on year

[A_Rosell]

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....

[v-jingzhang · Accepted 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.