Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
In the matrix table , there are 2 items under "Rows" : [Rollup Account Category ] and [Rollup], my goal is:
1. The order of [Rollup Account Category] is fixed.
2. The order of [Rollup] dynamically changes based on sorting of any "Values", when I click the header of any "Value".
I have created a column called : [Rollup Account Category Order], and set the "Sort by Order" of [Rollup Account Category] based on [Rollup Account Category Order], but I can not achive my goal in the report.
How can I achive that?
Thank you!
Branko
Rollup Account Category | Rollup | Rollup Account Category Order | Amount |
SALARIES | Employer Contributions | 1 | 26407.54 |
SALARIES | Salaries & Wages - Overtime | 1 | 99.18728 |
SALARIES | Salary Permanent Positions | 1 | 120292.9 |
SUPPLIES | Achievement Awards | 2 | 0.890459 |
SUPPLIES | Advertising | 2 | 0 |
SUPPLIES | Contract Services | 2 | 9640.873 |
SUPPLIES | Employee Travel | 2 | 1181.382 |
SUPPLIES | Honoraria | 2 | 10.60071 |
SUPPLIES | Hospitality, Corporate Event & Working Session | 2 | 500.6784 |
SUPPLIES | Insurance Expenses | 2 | 144.0177 |
SUPPLIES | IT Services | 2 | 1469.756 |
SUPPLIES | Legal Expenses | 2 | 18160.32 |
SUPPLIES | Materials & Supplies | 2 | 109.0389 |
SUPPLIES | Miscellaneous | 2 | 286.8763 |
SUPPLIES | MLA Expenses | 2 | 181.2438 |
SUPPLIES | Office Equipment & IT Supplies | 2 | 632.53 |
SUPPLIES | Other Employee Expenses | 2 | 664.6502 |
SUPPLIES | Other Services | 2 | 1059921 |
SUPPLIES | Publications Expenses | 2 | 2050.876 |
SUPPLIES | Rental | 2 | 320.9081 |
SUPPLIES | Repairs & Maintenance | 2 | 101.3039 |
SUPPLIES | Telephone and communications | 2 | 448.0035 |
OTHER | Allowances & Benefits | 3 | 703.5194 |
OTHER | Amortization of Tangible Capital Assets | 3 | 257.4346 |
OTHER | Capital Asset Acquisition | 3 | 0 |
OTHER | Grants | 3 | 599803.6 |
OTHER | Other Expenses | 3 | -1116.86 |
Solved! Go to Solution.
Hi @brankocareer ,
Thanks for reaching out to us.
In a table visual, you can sort by combination, for example, first by Rollup Account Category, then fixed, and then by Amount.
But, in a matrix, you can't do that, it's by design. You can either combine the Rollup Account Category and Rollup in the row to sort or sort the amount separately.
Here, the workaround is: go to data view, sort Rollup by Amount.
Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.
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
Hi @brankocareer ,
Thanks for reaching out to us.
In a table visual, you can sort by combination, for example, first by Rollup Account Category, then fixed, and then by Amount.
But, in a matrix, you can't do that, it's by design. You can either combine the Rollup Account Category and Rollup in the row to sort or sort the amount separately.
Here, the workaround is: go to data view, sort Rollup by Amount.
Of course, this workaround may also have limitations, which require further testing, but for now it is perfect.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.