Forum Discussion
Helper IReordering Columns in Field pane (powerbi Desktop)
Hi,
I require a bit of assistance, hoping it won't require too much of your time.
I have a straightforward table loaded into Power BI Desktop (sourced from a simple Excel file). Once I've imported the data into Power BI, I proceed to reorder the table using the Query Editor. I notice the table rearranges accordingly within the Query Editor. However, I also wish to reorder the same columns in the Field Pane on the right-hand side (within the data view). When attempting to drag columns up or down in the Field Pane, it doesn't allow for this adjustment. How can I resolve this issue so that the Field Pane columns reflect the same order I've arranged them in?
Columns before reordering are
Address | Name | Zip | DOB | Language | Marital | Gender
and Columns after reordering should be
Name | DOB | Gender | Marital | Address | Zip | Language
Source (Excel) table example below
| Address | Name | Zip | DOB | Language | Marital | Gender |
| Maryland | Jack | 25652 | 1945 | English | Married | MALE |
| New York | Josh | 24525 | 1972 | Chinese | Single | FEMALE |
| Hawaii | Manan | 35245 | 1985 | Japanes | Single | FEMALE |
| Taxas | Abraham | 36525 | 1997 | Spanish | Married | MALE |
| Washington | Hussain | 25225 | 2002 | Arabic | Married | FEMALE |
4 Replies
- danextian
Super User
Hi awsiya ,
While you can re-order the column in the query editor, it doesn't neccessarily affect the orders in the table/data view. The order follows the original order when the data was initially loaded. Columns created after that, either in M or DAX, are added to the rightmost part of the table. If you want to follow the order in the query editor, you will need to unload the table and then reload it back. Similar ideas have already been raised which you can vote for.
https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=column%20order
Hi awsiya ,
Please use the Table.ReorderColumns() Fuction:= Table.ReorderColumns(PreviousStepsName,{"Name", "DOB", "Gender", "Marital", "Address", "Zip", "Language"})Table.ReorderColumns - PowerQuery M | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
