Sorting matrix table

[GKJARC]

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!

[GKJARC]

@Ritaf1983 This works, thank you very much!
Be aware though that Number.From([Date]) doesn't always work well with datetime. For datetime I ended up using this SQL to get an inverted number from date: DATEDIFF(MINUTE, EE.ENTRYDATE, '2099-12-31T23:59:59') AS DateInvertedSorting

[Ritaf1983 · Accepted solution]

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