Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Change default sort by Total in Matrix

Hello,   I have the following matrix and I sorted it by the value MAT TY, but it is sorted default by the Total Column. How can I sort it by the 'Store 2' column for example? I already have the Sto...
Need Help
Stemar_Aubert's avatar
Stemar_Aubert
Resolver I
6 years ago

Hi Anonymous 

 

When you hover above the chart, you would see this appearing somewhere on a corner.

 

Click on this, then you can select a sorting column and order as well.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Stemar_Aubert ,

     

    Thank you for your reply. I sorted by the Value, but I can't choose the Column that I want (Store 2).

     

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Seem like no direct option. When there is no column you can sort by clicking. But when you have a column in matrix click do not allow to sort and even if sort by sort option, it is on grand total.

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi Anonymous , 

      According to your description, it seems that you want to sort specific column in Matrix by measure, right? As I know, this is not available currently. I think you could post this requirement in power-bi-ideas 

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.