Reordering Columns in Field pane (powerbi Desktop)

[awsiya]

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

[danextian]

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 

[v-cgao-msft]

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 Team

If 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

[awsiya]

Thanksm but this doens not change the order in Field pane in powerBi (which is on the righ hand side).

[danextian · Accepted solution]

Hi @awsiya ,

The order in the field pane is alphabetical while the order in the data/table view is as in my previous reply.