Forum Discussion

Chris3y's avatar
Chris3y
Frequent Visitor
7 years ago
Solved

Issues sorting one column by another when using filters

Hi,   Very new to PBI so the solution here, may be very basic. For reference, I'm using a Direct Connection to a local SQL db.  I have a table which is something like the following:   Primary ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Chris3y

     

    Based on my test, you may check the 'Title' column. The error is because it has duplicate values. If there is no duplicate titles it will not have error and it could be sort by row number as below pictures.

    Error

    correct

    Regards,

    Cherie

     

     

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

Hi Chris3y

 

Do you use table visual or others? It could be sorted without RowNumber column.

Regards,

Cherie

Chris3y's avatar
Chris3y
Frequent Visitor
7 years ago

v-cherch-msft

 

Rightly or wrongly, I'm specifically using the built-in "matrix" visual. The "Sort by Column" button is greyed out, even after selecting the "RowNumber" column from the field list. The button is only enabled if I add the RowNumber column to the visual which I'm trying to avoid. 

 

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

    Hi Chris3y

     

    Please follow below steps: 1. Click the 'Title' column 2. Click the 'Sort by column' and select 'RowNumber' column.

     

    Regards,

    Cherie

    • Chris3y's avatar
      Chris3y
      Frequent Visitor
      7 years ago

      That's what I've been trying all along. I tried again got the same message:

       

      "There can't be more than one value in "RowNumber" for the same value in "Title". Please chose a differenct column for sorting.

       

      I cannot understand why it's so difficult to sort by a non-visible field. To be clear, if I had the row number field to the Matrix, I can sort it without issue, simply by clicking its column heading. 

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

        Hi Chris3y

         

        Could you share the .pbix file or the sample data for your scenario? You can upload it to OneDrive and post the link here or send me via private message. Do mask sensitive data before uploading.

         

        Regards,

        Cherie