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.

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

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