Forum Discussion

awsiya's avatar
awsiya
Icon for Helper I rankHelper I
2 years ago
Solved

Reordering 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 impor...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi awsiya ,

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
awsiya
Icon for Helper I rankHelper I
2 years ago

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

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Hi awsiya ,

     

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