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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
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
8 years ago

Is there a way to implement this when in Direct Query mode? I had it working in import mode, but now the needs of my project have required direct queries

  • S184019's avatar
    S184019
    Advocate III
    8 years ago

    I don't think this exists as of yet.  I have been searching for a while. I even created my query to sort so that data would come into the query editor window in the proper chronologic order like this, 

     

      order by case when [Month] like '%Jan%' then 1
					   when [Month] like '%Feb%' then 2
					   when [Month] like '%Mar%' then 3
					   when [Month] like '%Apr%' then 4
					   when [Month] like '%May%' then 5
					   when [Month] like '%Jun%' then 6
					   when [Month] like '%Jul%' then 7
					   when [Month] like '%Aug%' then 8
					   when [Month] like '%Sep%' then 9
					   when [Month] like '%Oct%' then 10
					   when [Month] like '%Nov%' then 11
					   when [Month] like '%Dec%' then 12
					   end

    Still nada! If this isn't a suggestion for an improvement, I don't know what is. :smileytongue:

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I solved it by sorting by another column that I called date order

      • S184019's avatar
        S184019
        Advocate III
        7 years ago

        Anonymous

         

        Hey I agree there are work arounds.  I solved it the same way.  Most things MS are Drag and Drop and I am hoping to usher that same motif into life here. 

         

        Thank you for a great suggestion!