If the natural data can't support the sorting and filtering requirements, you might need to add an index column and sort by it.

Learn how to add a calculated column in Microsoft Power BI to enrich your data and provide easier insights with this guide.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.