The order in Matrix table

HI, brankocareer 

Based on your information, I create sample data

Add [Rollup Account Category] and [Rollup] to the row section of the matrix. Add [Value1] to the value section of the matrix.

Enable Interactive Sorting for [Rollup]. Right-click on the header of the [Rollup] column in your matrix. Select Text Box Properties. Go to the Interactive Sorting tab. Check the box for Enable interactive sorting on this text box. In the Choose what to sort section, select Groups. In the Sort by section, specify the field or expression you want to sort by (e.g., [Value1] or [Value2]).

To make it easier to see the sorting clearly, I've also created a matrix. Here is my preview:

You can learn more from the following link:

Interactive sort in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Add interactive sort to a table or matrix in paginated reports - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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