Forum Discussion

Sky's avatar
Sky
Frequent Visitor
9 years ago
Solved

Sort by Column does not work

Dear all,   I want to sort the results shown in a matrix based on Attrition Month Group: To do that I tried to sort the data based on Attrition Month (a column that does not exist in the matri...
Need Help
  • SaritaSenapati's avatar
    SaritaSenapati
    9 years ago

    Hi Sky,

     

    I think you still be able to solve this issue if you change the name of your attribution month groups as 00-01 momth AR, 02-03 monthAR, 04-13 month AR, 13-25 month AR and 25+ month AR and then you can directly sort it by Attrition Month Group.

     

    Regards,

    Sarita

     

     

     

Sky's avatar
Sky
Frequent Visitor
9 years ago

Thanks Sarita. I followed the steps that you had mentioned but still the results shown based on 'Attrition Month Group' is not shown as sorted. If I incorporate AttritionMonthText into the result, it is shown as sorted:

 

 

 

But it is not what I want, I don't want to show AttritionMonthText on the matrix. So when I remove it, the sort affact disappars. It looks like regardless of sorting the records in the model based on the Attrition Month Text, when this column does not appear on the matrix, Power BI does care about it and does the sorting based on 'the column' that is shown on the matrix, which is 'Attrition Month Group'.

 

Any idea?

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Sky

 

Did you apply this step:

 

4) Go to the modelling tab and select sort by attribution month.

 

Select Attrition Month Group From Fields Panel and Go to Modeling Sort by Column (AttritionMonthText)

  • Sky's avatar
    Sky
    Frequent Visitor
    9 years ago

    Thanks for reply Vvelarde. I get the error below, when I try to sort by attrition month text :

     

    We can't sort the 'Attrition Month Group" column by 'AttritionMonthText'. There can't be more than one value in 'AttriionMonthText' for the same value in 'Attrition Month Group'. Please choose a different column for sorting or update the data in 'AttritionMonthText'.

     

     

    It is all about grouping, so obviously there are more than one value (month) in AttritionMonth associated to a Attrition Month Group! Not sure what can be done to get the results of group sorted ....

    • SaritaSenapati's avatar
      SaritaSenapati
      Helper I
      9 years ago

      Hi Sky,

       

      I think you still be able to solve this issue if you change the name of your attribution month groups as 00-01 momth AR, 02-03 monthAR, 04-13 month AR, 13-25 month AR and 25+ month AR and then you can directly sort it by Attrition Month Group.

       

      Regards,

      Sarita

       

       

       

      • Sky's avatar
        Sky
        Frequent Visitor
        9 years ago

        Thanks Sarita. I followed your later suggestion and sorted based on Attrition Month Group directly. It doesn't look nice to have 0 before the numbers, but at least the result is now sorted right. Thanks for your help :)