Skip to main content

    Power BI

    Needs Votes

    select multiple columns for hiding/deleting in PowerBI Desktop

    Vote (314) Share
    M's profile image

    M on 18 Dec 2015 00:04:18

    Ability to select multiple columns (using ctrl/shift) for hiding/deleting in PowerBI Desktop in the Data mode

    Comments (28)
    M's profile image Profile Picture

    494de9f1 7b67-4827-9e42-0f19504dc444 on 05 Jul 2020 23:26:18

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Soheil from BIInsight shared a tip about that http://biinsight.com/quick-tips-hiding-multiple-columns-in-power-bi-desktop/

    M's profile image Profile Picture

    719d847a ecce-4417-bac6-b59200d425b8 on 05 Jul 2020 23:24:08

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    This would be good for applying format types too.

    M's profile image Profile Picture

    fe575d8e c762-44cf-98f6-e1977ed002e3 on 05 Jul 2020 23:20:31

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    This solution is good work around.

    https://datachant.com/2017/01/24/power-bi-pitfall-5/

    M's profile image Profile Picture

    3e6fb4a7 a77c-45fb-af27-b4650fe30439 on 05 Jul 2020 23:15:42

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Fully support the request. Huge waste of time.

    M's profile image Profile Picture

    64bedc96 5a7f-4d06-81f7-41f9747157bd on 05 Jul 2020 23:12:54

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    PLEASE MAKE THIS POSSIBLE

    M's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:11:25

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    'This was driving me crazy but I've found a quick workaround which only works if the columns are next to each other:

    - Hold down SHIFT and use the keyboard arrows keys to select multiple columns.
    - Press SHIFT + F10 to bring up the menu to hide the columns.

    Still not ideal but hopefully it will save someone a bit of time.

    M's profile image Profile Picture

    01fb7123 e3f5-44ce-9e99-f4c6258d91b8 on 05 Jul 2020 23:10:44

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Hi, vote for this feature as well. It's not rational at all to hide columns one by one.

    M's profile image Profile Picture

    7552de13 ad51-4227-955c-9f3b1f6f9f1d on 05 Jul 2020 23:10:36

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Imported entities from Dynamics CRM. And now so many columns that are not going to be of value in a report , am removing or hiding one by one. It is so time consuming...also accidentally hit "unhide all" and lost 2 hours of work, as there is no undo setting for this available.

    M's profile image Profile Picture

    123c9243 c0da-4c93-b1b8-475bbda0226f on 05 Jul 2020 23:08:26

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Very much agree this is a needed option. If you import an entity from Dynamics CRM; you are provided many columns that are not going to be of value in a report or dashboard. Removing them one at a time is almost not worth the time.

    M's profile image Profile Picture

    e4ebc37f 8f3a-456c-b545-67d8108b462e on 05 Jul 2020 23:07:19

    RE: select multiple columns for hiding/deleting in PowerBI Desktop

    Could you add a 'repeat last keystroke' button, while we wait for multiple column select?