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

Hi,
I had a similar issue.
interestingly it is working for one Matrix and not for Another.
I have recheck each and everything. 

Any suggestions

S184019's avatar
S184019
Advocate III
7 years ago

Anonymous  

There seems to be a bug in the order system. The way around it is to make sure that you have numbers as numbers, text as text, and dates as dates.  Then make sure that you click on the field list on the right side.  click on the field you want to be sorted.  Then click off the field, but onto another field in the same table of the field list. 

 

Then click back on the field and then the modeling should show up as sort by column.  When it does, choose the field you want to sort the field by.  So for example maybe you want to sort your organization by date. Click on org then off of org then back on to org. Then int he modeling tab at the top, the Sort by Column button will be available.  Click on that and then chose date.  This will sort your org by date.  Hope this helps. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi 

    Thanks S184019 

    I am able to achieve it.

    But facing same issue for Horizontal Slicer visual.

    I am also not able to get help with the Sort Option the visual provides.

    I need to sort by Index which I have mentioned.

    Could you suggest.

    • S184019's avatar
      S184019
      Advocate III
      7 years ago

      So the challenge is on how to sort the values in slicer?  If so, I found this: 

       

       

      1. Create a new table (in query editor) that has a column of distinct values that you are using in your slicer.
      2. Add a numeric column using whatever logic you need based on the desired order.
      3. Close and Apply to load this new table to data model, then create a relationship to your fact table.
      4. Click on the new field of distinct values, then click on the Modeling tab and select Sort by Column.  Choose the numeric column that you created to provide the order.
      5. Use this distinct list in your slicer.

      Did this help?