Forum Discussion

GKJARC's avatar
GKJARC
Resolver I
2 years ago
Solved

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 asce...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

     

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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