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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

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
canufrank
New Member
shocked that this does not have more votes - such a nightmare
Steve_Fanner
New Member

This is still needed in 2023/24. Unless you have pre-planned every calculated column that you want to add, you cannot always group together the various permutations of columns that belong next to each other, making it more difficult to check that you've created all the required columns, or be able to navigate to them.

fbcideas_migusr
New Member

I have been playing around with Power BI for about 30 mins to evaluate if it's a good fit for our use case. This is so basic that I have pretty much ruled it out already. I should probably continue for a bit but this is so shockingly basic a flaw that my first instinct is to throw the whole thing in the bin already. At this point Crystal reports c1995 looks a better product.

Jared_Kehler
New Member

Such a base functionality, amazed at the oversight to not add it in.

menachem
New Member

As a power BI user I'm honestly kind of embarrassed that this is still not taken care of.

rmccord
New Member

This is a highly necessary basic need. As my report has grown and I've had to add calculated columns, there are fields that need to be grouped together but cannot. This if very frustrating.

yashasvi_patel
New Member

Highly disappointed to see such basic functionality missing.

fbcideas_migusr
New Member
Status changed to: Needs Votes
 
UW-DA
Frequent Visitor

Still shocked this is not at least a planned change. What I'm most surprised about is that this wasn't part of the original release of Power BI from day one. In my setting I often copy the data tables to provide to individual non Power BI users when testing. For established Power BI files I still have a need to copy a table and paste in excel for various reason. I wouldn't think this added BASIC feature would take that long to script, test, and put into preview. 

Halo
Regular Visitor
Very frustrating indeed. Sometimes, I simply miss Excel...