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

    Luigi R 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

    Marshall 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

    Steven Wright 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

    Diogo Almeida on 06 Jul 2020 00:09:27

    RE: Moving/Rearranging Calculated Columns

    Plus one!

    Sean's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:07:52

    RE: Moving/Rearranging Calculated Columns

    '+Yes please

    Sean's profile image Profile Picture

    Sam on 06 Jul 2020 00:05:59

    RE: Moving/Rearranging Calculated Columns

    '+1 very interesting idea

    Sean's profile image Profile Picture

    Isadora Stoianoff 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

    Marcus Williams on 06 Jul 2020 00:05:08

    RE: Moving/Rearranging Calculated Columns

    Bump.

    Sean's profile image Profile Picture

    Wyn Hopkins 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.

    Sean's profile image Profile Picture

    renan on 06 Jul 2020 00:03:57

    RE: Moving/Rearranging Calculated Columns

    Please enable the Rearranging of all columns (even non calculated ones).