Difference between data loaded into Power Query editor and Data Tab in Power BI Interface

[Novice_]

The format of the column is Text+number. Although it's in the correct order in Power Query Editor, after applying the transformations (only deleted 2 columns and changed the data types), it completely jumbles up in the Data Tab in Power BI interface regardless of trying to sort it by the column (and this particular column). Please refer to the following tables to understand the problem:

Power Query Editor:

Year

FY20

FY20

FY20

FY21

FY21

FY21

Data Tab in Power BI Interface:

Year

FY20

FY21

FY21

FY20

FY20

FY21

I am unable to understand the underlying issue and its corresponsing solution. Any help would be deeply appreciated!

Thanks,

Novice_

[mahoneypat · Accepted solution]

The order of the rows in the table won't impact any of your visuals/analyses.  If needed, you can add sort by columns to get a category column's values to display in something other than alphabetical order.  In your case, FY20 will come before FY21 in a visual.

Pat