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

So is there no way to do this?  My question just got pushed to the second page of the forum.  Can anyone recommend any other forums where there are more Power BI Users?

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Bump

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

    Hi Anonymous 

     

    You may use Sort by column for Account Subgroup column like below.

     

    Regards,

    Cherie

    • 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