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

This is the demonstration file to accompany the article, How to add a calculated column in Microsoft Power BI by Susan Harkins.

Learn how to use Power BI measures and calculated columns to create dynamic, optimized reports. Step-by-step guide with examples and tips.

Learn how to transform Power BI column charts into visually stunning tools with tips on conditional formatting, dynamic titles & interactivity ...