Skip to main content
Microsoft Idea

Power BI

Needs Votes

Moving/Rearranging Calculated Columns

Vote (1089) Share
Sean's profile image

Sean on 24 Aug 2015 23:46:03

I'd like to be able to move/rearrange my Calculated Columns in the Data View so they can be placed next to columns where they would be more relevant and make more sense.


It would be nice also if the Calculated Columns are shaded darker as in PowerPivot so we can easily distinguish them.


Also please enable Ctrl+A (Select ALL) in the Data View - currently it works only in the Query Editor.


This way we could Select ALL Data in the Data View where it would include the Calculated Columns.

Comments (86)
Sean's profile image Profile Picture

Daniel Cassidy on 03 Apr 2023 15:49:26

RE: Moving/Rearranging Calculated Columns

How is this still not done.

Sean's profile image Profile Picture

PowerBI Admin on 27 Feb 2023 17:31:48

RE: Moving/Rearranging Calculated Columns

This is one of the few things that Power Pivot does better. Completely ridiculous that I have similar column spread all over the view . On some tables i have bunch of calculated columns first then the data off screen to the right as i changed the power query after writing a bunch of calculated columns.


All these fancy new visuals are just irrelevant when you can understand your data structure easily

Sean's profile image Profile Picture

Michaela MAIER on 24 Jan 2023 09:48:54

RE: Moving/Rearranging Calculated Columns

@Microsoft please update this! It is extremely annoying and messy when the column order is the same order like you created them.

Sean's profile image Profile Picture

Andrew Ashurst on 22 Dec 2022 17:30:51

RE: Moving/Rearranging Calculated Columns

I'm a little confused by those who say that tables should at least load in the order they are arranged to in Power Query, because, for me, that does appear to happen. I would be content, at least as an interim solution, with a situation where the order of the PQ imported columns is fixed (by Power Query) and always at the left, but, where new calculated columns in the modelling layer (of whatever kind) could then be re-arranged as needed within the block to the right of the imported PQ columns. I also support the idea of having some visual cue, as there is in Excel Power Pivot datamodel, showing which are imported columns from PQ and which are being calculated in the model layer.


I hope I now find out that this is now possible as a recently introduced feature, but, I guess I won't.

Sean's profile image Profile Picture

Andrew Ashurst on 22 Dec 2022 17:23:19

RE: Moving/Rearranging Calculated Columns

There seems to be some confusion about this among some here and in the wild generally. Columns order from Power Query is defined there and is easily changed there before loading the table to the modelling layer. What the problem seems to be is that calculated columns added in the "modelling" layer of power bi cannot be inserted where would make sense but always appear in the furthest right column and then cannot be moved from there. AFAIK there is no easy way to re-group them into a sensible order that makes sense to the modeller (or later perhaps to others who are having to adopt the model or develop it further). There is a solution suggested using the function SELECTCOLUMNS but it seems an unsatisfactory and unnecessary workaround, even if it works, I will look, users need to be able to drag and drop. I annoyed too that what would seem to most to be a basic requirement is taking so long to implement, with, as ever, no dialogue that I know of from MS explaining why this is taking so long or is so difficult.

Sean's profile image Profile Picture

Luis Mariano Mingo Anaya on 24 Nov 2022 08:15:02

RE: Moving/Rearranging Calculated Columns


The minimum would be that the order of the columns in the table view was the one imported from powerquery.

Sean's profile image Profile Picture

Darla Walker on 18 Nov 2022 17:02:23

RE: Moving/Rearranging Calculated Columns

We need to be able to change the order the fields and folders are displayed. Currently it makes no sense to the end users and is jeopardizing our move from OBIEE to Power BI.

Sean's profile image Profile Picture

Matt L on 11 Oct 2022 18:08:53

RE: Moving/Rearranging Calculated Columns

Adding my vote..

Sean's profile image Profile Picture

Kal Vanderschalk on 28 Sep 2022 08:02:03

RE: Moving/Rearranging Calculated Columns

Please

Sean's profile image Profile Picture

Sara Flood on 27 Sep 2022 13:04:47

RE: Moving/Rearranging Calculated Columns

We have reports in Tableau, Qlikview and PowerBI in our org. Making the manipulation of data more agile in PowerBI will drive more users towards this tool for data analysis.