Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI.

Unlike Microsoft Excel, Microsoft Power BI doesn’t have the ability to build custom sorts. However, you can sort one column by another, which is effectively the same thing and easy to implement.