Forum Discussion
Power BI Data Tables Not Maintaining Column Order
Hi, In Power Query, I sorted a table per the below example: Column_abc, Column_bcd, Column_cde When I close and load the table and view it in the Data Table view it has a different column or...
Hi Anonymous
take a look at this blog post:
https://blog.crossjoin.co.uk/2018/12/18/power-bi-and-column-order-in-m-queries-and-dataset-tables/
This worked for me: Click on Table > Transform > Advance Editor . Add a line called "Table.ExpandableColumn(Your column names seperated by a ,")
This should order the columns how you want it. (I wanted the Area Code to appear before Area Name in Table view)