This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi everyone,
I have a matrix table with a 2-level hierarchy (so two columns in the 'Rows' section): Customer name and Date.
Customer name is sorted alphabetically ascending.
Date I need sorted descending so that the latest date appears at the top.
So the desired sort order would be like this:
| Customer name, Date |
| - Customer A |
| 01-03-2024 |
| 01-12-2023 |
| 01-06-2023 |
| 01-10-2022 |
| + Customer B |
| + Customer C |
How can this be achieved?
Any help would be greatly appreciated.
Thanks!
Thanks @samratpbi for your reply.
I'm affraid my post lacked the important detail that the hierarchy can have up to 4 levels and only the first level should be sorted Ascencing, the others should sort Descending so the latest on top like this:
| - Customer A |
| - A3 |
| 01-03-2024 |
| 01-12-2023 |
| 01-06-2023 |
| 01-10-2022 |
| + A2 |
| - A1 |
| 01-06-2019 |
| 01-04-2019 |
| 01-03-2019 |
| 01-10-2018 |
| + Customer B |
| + Customer C |
Hi, I have created 1 sample table like below:
Then after putting values in a matrix visual, applied this sort option:
As you may see, Customers are asc and dates under a customer are desc.
If this resolves your proble, then please mark it as solution, Thanks!
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 61 | |
| 36 | |
| 29 | |
| 22 | |
| 21 |