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

    2a19cd85 e3ea-ea11-a817-000d3a579c34 on 30 Aug 2020 17:10:13

    RE: Moving/Rearranging Calculated Columns

    +1

    Sean's profile image Profile Picture

    342ebc94 c6c9-ea11-a813-000d3a579c38 on 21 Jul 2020 16:20:22

    RE: Moving/Rearranging Calculated Columns

    Please pay attention to the user interface aspects (this like several others): it is essential for an efficient, effective and therefore winning software tool.
    Thanks

    Sean's profile image Profile Picture

    f9ce71fd d3d1-4e9a-979c-7676975c9082 on 06 Jul 2020 00:13:53

    RE: Moving/Rearranging Calculated Columns

    UNION joins will only work if your two tables are exactly ordered the same way. If you have two tables with the same fields but different order, you are out of luck.

    Sean's profile image Profile Picture

    07ea7300 f282-4cef-8062-e2b4ba21b194 on 06 Jul 2020 00:12:11

    RE: Moving/Rearranging Calculated Columns

    This feature would enable the ordering of fields - especially calculations when you are building up the full set of functions. Also it would help when you need to later add additional calculated fields that are related to previous ones!

    Sean's profile image Profile Picture

    8f2130e5 6bc4-4813-bbc8-5e56104425c7 on 06 Jul 2020 00:09:27

    RE: Moving/Rearranging Calculated Columns

    Plus one!

    Sean's profile image Profile Picture

    752303c3 67c4-4252-9450-84381d010d58 on 06 Jul 2020 00:07:52

    RE: Moving/Rearranging Calculated Columns

    '+Yes please

    Sean's profile image Profile Picture

    8f6329aa d366-4b14-9b25-fcfe250822b5 on 06 Jul 2020 00:05:59

    RE: Moving/Rearranging Calculated Columns

    '+1 very interesting idea

    Sean's profile image Profile Picture

    792d425b 284e-4a89-982d-a83e0603a5a5 on 06 Jul 2020 00:05:40

    RE: Moving/Rearranging Calculated Columns

    For me its very important this, once I need to compare date of different tables.
    Waiting anxiously.

    Sean's profile image Profile Picture

    4489f026 b4a9-4698-83aa-ccde5dc4350c on 06 Jul 2020 00:05:08

    RE: Moving/Rearranging Calculated Columns

    Bump.

    Sean's profile image Profile Picture

    0074d8fc eba5-4dcc-96de-4d3c3109aff7 on 06 Jul 2020 00:04:39

    RE: Moving/Rearranging Calculated Columns

    This is really important.

    Also if you add a DAX calc column and then go back to Power Query and add another column there there's no way of seeing which columns are which in the data view. And they are all mixed up.