Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Moving/Rearranging Calculated Columns

    Vote (1122) 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 (89)
    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.

    Sean's profile image Profile Picture

    Stephen Davies on 05 Jul 2020 23:20:11

    RE: Moving/Rearranging Calculated Columns

    '+1