Sorting by Start Time w/ Microsoft Gantt Chart

[Anonymous]

Hi,

I'm using Microsoft's Gantt chart, a custom visual, in my project. I must include a field for start date, and I have a choice of including either end date or duration. If I include end date, I have the option to sort along the x-axis for earliest end date. If I include duration, I can sort by sum of duration.

How can I sort by start time? There is no option for this that I can see. I have attempted to build custom sorting, but have been unable to due to the chart's refusal to accept measures in any field.

Thanks.

[wardy912 · Accepted solution]

Hi @Anonymous 

 The Gantt visual automatically sorts by start date, but gives you the option to sort by end date/duration.

Don't sort the x-axis by any other options and you should be fine.

Hope this helps, please mark as solved if it does.

thanks.

[Anonymous]

This only allows sorting in ascending order. Any idea how I can include it as a sorting option so I can sort by descending?