Forum Discussion
Sort By Column (non-unique values)
The data is from a view so I created a table on the server listing all possible grade-subject level combinations and manually ranked them best-to-worst. I linked the table to to view.
I've also tried importing the table as its own data set and linking within Power BI Desktop. I can look the correct values up this way, but I can't sort on them. 😞
Hi Richard_WQE , thank you for your explanation.
In this new table, were you able to "sort by column" based on your custom rank? If so, in order to use this new column to sort the grades in the wanted way, I suggest you creating a relationship between the 'sort table' and the 'original table', and then use the column from the 'sort table' instead of the original one in the visuals (matrix in this case).
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍
Thanks!
Best regards,
Joao RibeiroI cannot. Same error as when I try within the main table.
The grade (in this case the Minimum Expected Grade) isn't unique because, as before, different subject levels can have same grade, so grade isn't unique.
I see! Unfortunately, there is no workaround for the sort by column without unique values. In this case, can't you create the sorting rank based on the combination of two columns (subject-level)?