Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reordering columns in the Data view

I have yet to work on a report in which the columns in my dataset are not arranged in a strange, illogical order, with my most-used columns lost somewhere in the middle, and groups of logically-related columns spread out over the table. The Query Editor already allows for this, but calculated columns and tables are not available in the Query Editor view. As a result, I spend too much time trying to plan the order I will create calculated columns so that I will be able to easily access them later. If there were an easy way to move columns around in the Data view, either by simply dragging (as in query editor) or by highlighting and shift-dragging (as with Excel tables), then this would save a lot of time and headaches due to searching left and right to find a column.
Status: Needs Votes
Comments
ExcelMonke
Super User
Bumping this for visibility. Hopefully MSFT can get this fixed, or at least explain why the reordering of columns doesn't work.
richeerich
New Member
I am SHOCKED I can't reorder the columns in Table view. I am also shocked that reodering columns in PowerQuery is not reflect in the report even after a schema refresh. What. the. heck.