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
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
Hi Nathaniel_C , thanks for that - yep i do have an index column for the table (see the first column order). but it only works if i want to organise my second column (FLITS_Spec) and if i try to use the same index column for my third column (Log_summary) it tells me it can't sort.
i am guessing i can get around it by creating another table for Log_summary and unique index column but just wonder if i can get around this?