Forum Discussion
Gantt Chart - Sorting Issue
Hello, I've an urgent issue in Gantt Chart. Unfortunately we cannot solve the sort. Initially we solved putting the number before task name, but if you see the task 6,7,8 is after the 050 but ...
FINALLY GOT IT TO WORK
Assuming Excel Workbook as input data
Set WBS field to 'Text' format
Change WBS 1-9 to 01-09
| 01 |
| 02 |
| 03 |
| 04 |
| 05 |
| 06 |
| 07 |
| 08 |
| 09 |
| 10 |
| 10.1 |
| 10.2 |
| 10.2.1 |
| 10.3 |
| 10.3.1 |
| 10.4 |
Concatenate WBS and TASK Name in new Excel Column
=concat(WBS, " - ", Task)
Use WBS Task in Power BI 'Task' data
Using ellipses in upper right corner of visual, sort by WBS, sort order Ascending