Forum Discussion

Srikarnandan7's avatar
Srikarnandan7
Helper I
9 years ago
Solved

Sorting on Total Column in Matrix

Hello Team,

 

I have a matrix with Total column, I now wanted to sort on 'Total' but I could not sort on it. can u please guide me how to sort on Total in Matrix.

General Comment
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Srikarnandan7,

    Step1: Added ID column to Values and changed that to Count

    Step2: Created new column 'Total' for sorting  with below expression

    Total= COUNT('test'[ID]) 

    Step3: I applied sorting on 'Total' column using 'Sort by Column', didn't work.

    Please suggest me, am I missing something?

    I'm not sure I understand step2. What do you mean about creating new column 'Total'? Based on my understanding, a Grand Total column should be added to the Matrix without any action. Could you be more precisely with it? :smileyhappy:

     

     

    In addition, it could be better if you could share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

     

    Regards

7 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Srikarnandan7,

     

    I just verified that I can sort on the 'Total' column on Matrix visual with the latest version of Power BI Desktop(2.48.4792.721 64-bit (July 2017)). :smileyhappy:

     

     

    What version of Power BI Desktop are you using? 

     

    Regards

    • Srikarnandan7's avatar
      Srikarnandan7
      Helper I
      9 years ago

      Hi v-ljerr-msft

      Thanks for the reply, I'm using 2.47.4766.801 64-bit.

      Is that feauture availabe from 2.48.4792.721 64-bit?

       

      Thanks,

      Srikar

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        Hi Srikarnandan7,

        Is that feauture availabe from 2.48.4792.721 64-bit?

        I don't think it is. However, could you try with this version of Power BI Desktop to see if it work for you? :smileyhappy:

         

        Regards