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.