Forum Discussion
Sorting matrix table
Hi everyone,
I have a matrix table with a 4-level hierarchy (so four columns in the 'Rows' section): Customer name and Date.
The first column is Customer name which is sorted alphabetically ascending.
The other 3 columns I need sorted descending.
So the desired sort order would be 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 |
How can this be achieved?
Any help would be greatly appreciated.
Thanks!
Hi GKJARC
You need a "sort column" for every hierarchy level in your table with the needed order and sort the columns from the data view:For a date column, you should use a date table create the column with the numeric date value and multiply it to (-1):
Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
Hi GKJARC
You need a "sort column" for every hierarchy level in your table with the needed order and sort the columns from the data view:For a date column, you should use a date table create the column with the numeric date value and multiply it to (-1):
Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
