Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Matrix Column Head Order

  Is there a way to change the order of the column heads in a Matrix table.  Currently it displays in alphabetical ascending order.  I would like to reverse that if possible.  A prefered option ...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    We can do that with following steps. Assuming we have a table like below. We can add a reverse index.

     

    Close and apply Query Editor, select the Type column and make it sort by column of Index.

     

    Now the order of the column heads will follow the Index.

     

    If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.

     

    Best Regards,

    Herbert

Anonymous's avatar
Anonymous
Not applicable
7 years ago

For this topic- ok. Because, here uses a Matrix with a Table, where it showed how to reorganize the Table. But when do you want to sort by a measure and columns? (example: structure of a Dimension containing only "measures" separately). How to create multiple sorts by measures and columns? (% accumulated order descending + State + Name + etc