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

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.

Sean's profile image Profile Picture

Stephen Davies on 05 Jul 2020 23:20:11

RE: Moving/Rearranging Calculated Columns

'+1

Sean's profile image Profile Picture

Morgan Thomas on 05 Jul 2020 23:02:11

RE: Moving/Rearranging Calculated Columns

This is a must have... How has it not been incorporated yet?

Sean's profile image Profile Picture

Daniel on 05 Jul 2020 23:01:22

RE: Moving/Rearranging Calculated Columns

Please

Sean's profile image Profile Picture

Eric on 05 Jul 2020 22:56:13

RE: Moving/Rearranging Calculated Columns

A must have! Sometimes I want to see all the data... without a visual... and proximity makes a huge difference in speed of comprehension.