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 create a dashboard in Power BI using this guide to help organizations make better, more informed and faster decisions.