Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to 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.
Proud to be a 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
Proud to be a Super User!
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
Thanksm but this doens not change the order in Field pane in powerBi (which is on the righ hand side).
Hi @awsiya ,
The order in the field pane is alphabetical while the order in the data/table view is as in my previous reply.
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
98 | |
96 | |
87 | |
68 |
User | Count |
---|---|
167 | |
134 | |
129 | |
103 | |
96 |