Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hiding A Sorting Row in A Matrix

Please help me with my Matrix.   I have a matrix I created so that users can drill down to lower levels to see what values live underneath them.   The problem I am having is that I want to sort b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cherie,

 

The sort by column button is greyed out for me so that I cannot select it.  I should also reiterate that I am using a matrix, which might have different rules for use with regard to sorting, no?

 

I did find information out there on how to sort on a hidden column for a "Table" visualization and a "Chart" visualization, but not for a "Matrix" visualization.

 

Please let me know.


Thanks.

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

 

Please select the column you want to sort first.Then click sort by column.Attached the sample file for reference.

 

 

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    None of these suggestions work.

     

    After much research by my boss and I, we are going to have Microsoft get involved and tell us how to make this work.

     

    I simply want to sort by a hidden column in a Matrix.  I should be able to add a column field to the Matrix, or a query, or a Dax created field, and sort it, then somehow hide it.

    • michellepace's avatar
      michellepace
      Resolver III
      7 years ago

      Hi Anonymous , its actually quite a simple process to do what you need. It's just difficult to describe in words. I've made a little video for you. The trick is sorting the AccountSubGroup field by the LEVEL field (make sure your Level field is already sorted in ascending order). Here you go:

       

      How to sort a matrix by a "hidden" field: https://youtu.be/n7VYW-vfCrY

      • dom99's avatar
        dom99
        Advocate V
        6 years ago

        Thanks for the youtube video. Without it I wouldnt have got this working, I didnt realise you had to order the specific column by the column you want to sort by (I can see why describing it is difficult). 

         

        Anyway thanks :)