Sort Paginated Report Dates

[EmsH212]

I am wanting to sort my dates from old to new in a paginated report I am trying to create.  I am using a Dataset Direct query and DAX code from the PowerBI report for the Datasets.  How can I add a filter?  I have tried many different options and nothing works.  It will time out in "Run", stating the dataset is too large or it will not open anything. 

[Anonymous]

Hi @EmsH212 ,

Thanks for reaching out to our community. Here're the official documents about them:

Filter, group, and sort data in Power BI paginated reports - Power BI | Microsoft Learn

Add a filter to a Power BI paginated report - Power BI | Microsoft Learn

Here's a video tutorial on sorting in the table, the video is usually easier to understand, please refer to:

12 Days of Paginated Reports - Day 9 - Sort a Table - YouTube

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.