It would be valuable to have consistent and controllable task sorting behavior in Gantt visuals across Power BI Desktop and Power BI Service, especially when hierarchical fields (such as parent/grouping fields) are used.
Visual: Gantt 3.4.5.0 by Microsoft (AppSource)
Currently, visuals may behave differently depending on whether a hierarchy is applied, and sorting can shift from expected alphabetical ordering to alternative criteria without a clear way to override this in the Service.
- In Power BI Desktop, tasks grouped under a Parent field sort A→Z as expected.
- In Power BI Service, adding a Parent field causes tasks within each parent group to sort by Start Date instead, with no reliable way to enforce alphabetical order.
Suggested improvement:
It would be valuable if the Microsoft Gantt visual (and/or Service rendering) supported explicit, enforceable task sorting within
parent groups that remain consistent between Desktop and Service. Specifically:
- Respect model-defined sorting metadata (e.g., Sort by Column) when a hierarchy/Parent is used
- Provide a Service-side override to choose task sort (e.g., Task Name A→Z) within each parent group
- Avoid defaulting to date-based ordering when Parent/grouping is present unless explicitly selected by the report author
It should
- Allow users to explicitly define and enforce sorting logic (e.g., alphabetical by task name) within grouped hierarchies
- Ensure that sorting configurations and metadata defined in the model or Desktop are consistently respected in the Service
- Provide a clear and accessible way to override default sort behavior within the Service UI for hierarchical visuals
No CommentsBe the first to comment
