Forum Discussion

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
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

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'.