Skip to main content

    Power BI

    Needs Votes

    Moving/Rearranging Calculated Columns

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

    9d3625ea 214b-4b02-9539-83637d4f1009 on 05 Jul 2020 23:36:29

    RE: Moving/Rearranging Calculated Columns

    Gah - so annoying!

    Sean's profile image Profile Picture

    dafb1c55 8997-49a4-903b-bc6de5c397c1 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

    e38e5a71 974a-4d1c-9bc9-42f9b677e506 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

    5c3d784a 08b3-492a-91c5-5d8d01203ea1 on 05 Jul 2020 23:34:56

    RE: Moving/Rearranging Calculated Columns

    '+1

    Looking forward for this function.

    Sean's profile image Profile Picture

    cfead8ce b9b9-4a20-b062-016779936f02 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

    dbe450ab fdc6-4e44-b5e0-82179b63d83f on 05 Jul 2020 23:28:00

    RE: Moving/Rearranging Calculated Columns

    Agreed this really needs to happen

    Sean's profile image Profile Picture

    ae7d8561 348a-4728-a79f-faeea1967e3c on 05 Jul 2020 23:27:46

    RE: Moving/Rearranging Calculated Columns

    '+1

    Sean's profile image Profile Picture

    aa5d0e5b 67fb-4c39-89a7-a2111d72381a 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

    3fa2282d 1bb5-4761-a0d5-d838b886acd6 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

    1f01e070 45e1-472b-bab7-05c477366026 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.