Forum Discussion
Sort by Column does not work
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
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 :)
Hi Sky,
If you want it too look as what you wanted, you can create a relationship table for the month group . Connect it to your fact table and it will give you an outcome like this
I'm trying to solve this same problem, and followed osoosh's recommendation, but I get the error below (I replaced the column names in the error popup so it's easier to follow-- "Trying to sort" is the column of with data that I'm trying to sort a different way, and "Sort column" is the separate data I created with sort order values):
Sort by another column
We can't sort the 'Trying to sort' column by 'Sort column'. There can't be more than one value in 'Sort column' for the same value in 'Trying to sort'. Please choose a different column for sorting or update the data in 'Sort column'.
"Sort column" is set up with a one-to-many relationship with the data in "Trying to sort", and each value in "Sort column" is distinct (aka there isn't more than one value for the set of values in "Trying to sort", as the error message claims). As far as I can tell, the data I'm working with is the same type as discussed in this thread, so I'm confused as to why this solution isn't working. What am I doing wrong? I'd be happy to share screenshots if there isn't an obvious solution.
I'm trying to solve this same problem, and followed osoosh's recommendation, but I get the error below (I replaced the column names in the error popup so it's easier to follow-- "Trying to sort" is the column of with data that I'm trying to sort a different way, and "Sort column" is the separate data I created with sort order values):
Sort by another column
We can't sort the 'Trying to sort' column by 'Sort column'. There can't be more than one value in 'Sort column' for the same value in 'Trying to sort'. Please choose a different column for sorting or update the data in 'Sort column'.
"Sort column" is set up with a one-to-many relationship with the data in "Trying to sort", and each value in "Sort column" is distinct (aka there isn't more than one value for the set of values in "Trying to sort", as the error message claims). As far as I can tell, the data I'm working with is the same type as discussed in this thread, so I'm confused as to why this solution isn't working. What am I doing wrong? I'd be happy to share screenshots if there isn't an obvious solution.
Hi bslattery,
Mmmm it sounds strange. Are you certain that the values in the sort column is distinct? It sounds like Power BI finds more than one value to sort by for a given value in the Trying to Sort column. Could you please send some screen shots, it might help.
