Skip to main content

Power BI

Needs Votes

Moving/Rearranging Calculated Columns

Vote (1144) 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 (90)
Sean's profile image Profile Picture

Michael Hughes on 05 Jul 2020 23:36:29

RE: Moving/Rearranging Calculated Columns

Gah - so annoying!

Sean's profile image Profile Picture

Brooke on 05 Jul 2020 23:36:14

RE: Moving/Rearranging Calculated Columns

In my opinion this change is absolutely crucial. The issue has been open since 2015 and no change has been implemented, please listen to us Power BI team!

Sean's profile image Profile Picture

Kirsty on 05 Jul 2020 23:36:05

RE: Moving/Rearranging Calculated Columns

Please, please Power BI team... make our data organisation dreams come true. It is so frustrating when we have a perfectly formed table, edit the name of a field and suddenly the key is on the right. My brain cannot cope with this. Please help.

Sean's profile image Profile Picture

Rolands on 05 Jul 2020 23:34:56

RE: Moving/Rearranging Calculated Columns

'+1

Looking forward for this function.

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:05

RE: Moving/Rearranging Calculated Columns

So so valuable! When enriching data and trying to order mesures away from data characteristics and like data together

Sean's profile image Profile Picture

Mathew Power BI User on 05 Jul 2020 23:28:00

RE: Moving/Rearranging Calculated Columns

Agreed this really needs to happen

Sean's profile image Profile Picture

Wenjie Tang on 05 Jul 2020 23:27:46

RE: Moving/Rearranging Calculated Columns

'+1

Sean's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:41

RE: Moving/Rearranging Calculated Columns

Another reason to do this is that when you create a Union in DAX the fields in both files have to be arranged in the same order otherwise you will get the wrong data after the Union is performed :(

Sean's profile image Profile Picture

Felipe on 05 Jul 2020 23:22:26

RE: Moving/Rearranging Calculated Columns

I'd like to be able to move / rearrange all of the data model's columns in "Data" view. No reason to limit this to calculated columns.

Sean's profile image Profile Picture

Adam Kruzel on 05 Jul 2020 23:21:50

RE: Moving/Rearranging Calculated Columns

One key example of when I need this is when I use the DAX path () function to lay out a hierarchy and after separating the columns using pathitem () , i may add new columns that i need to reference but want to strategically place them to make the most sense and i can't.