Rows not sorting properly

[J_Hughes83]

I have a dataset with a column called row number that is imported from the smartsheet, the row number runs from 1-1901, incremeting by 1. In PowerQuery it loads in numeric order. In the Data Model, it usually starts at 649 and has random groupings, usualy 10-20 numbers in order in a row, then it jumps to some other set of numbers, I have had it start with several different numbers, occasionally I have had it change just by me saving the query.

I am trying to display the data in the Microsoft Gantt visual in numeric order by the row number column, but it is showing in the order in the Data table.

I added an index and tried to sort my row number column by the index in the data model, but it still sorts starting at 649. Sorting the row number column by ascending puts the rows in the correct order in the table view, but does not change the order in the visual. How can I get this to sort in order so it shows in the proper order in the visual?

[hvnter]

Make sure the column you're sorting by, isn't sorted by something else 

[J_Hughes83]

is there a way to see and/or clear what is sorting by what?

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[lbendlin]

Neither Power Query nor Power BI give any sorting guarantee unless you specify how you want stuff sorted.  Adding the index is the right first step.  Next step is to use the "Sort one column by another column"  feature.

[J_Hughes83]

I did use the sort by column option, I used the index to sort the row # column and it still starts with 649

[HotChilli]

Are you using 'sort by column' functionality?

I haven't used the Gantt visual but this is what you need.  Try testing it in another visual type if you can't get it to work in the Gantt.