Forum Discussion
Column order
Hi Anonymous , not sure if am clear about what you are trying to do, but one way to do it, is to sort in Power Query, the way you would like to se it, and then add an index column. Then going back to Power BI, you can use the column sort by on the ribbon, and sort the log col by the index column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
It has multiple orders for same GradeComb in the table, it's not possible to custom a sort order column to have the GradeComb column sorted by this numeric column.
In your case, like the previous commenter said, you cannot use the same sort order field as for the initial field (since values likely aren't distinct). However, that doesn't need to stop you from creating a new sorting field!
For example, create a table that looks like:
GradeComb SortOrder
Purned 1
A/30 2
Pulp 3
Then, link this table to your existing table. Then, in the existing table, create a new field called "Sort Order for States" that is just =related(SortOrderTable[SortOrder]).
Then, that field becomes the one you can use to sort your groups using the "Sort by column" button in the modeling tab.