Skip to main content

    Power BI

    Needs Votes

    Hide/Show Column on Table

    Vote (297) Share
    's profile image

    on 22 Aug 2017 15:55:59

    Column visibility , depends on the criteria there should be an option to show/hide column on table.

    Comments (36)
    's profile image Profile Picture

    947d262a c40c-45f4-bf37-d9b6a38485d0 on 05 Jul 2020 23:53:56

    RE: Hide/Show Column on Table

    '
    +1

    's profile image Profile Picture

    6f7a4840 7641-4b2c-8a74-052ae0eebf6f on 05 Jul 2020 23:51:03

    RE: Hide/Show Column on Table

    There should be an option to hide the column in report table visual and supported by conditional formatting.

    's profile image Profile Picture

    bb65a3a1 8174-4571-ae5f-117b453bd406 on 05 Jul 2020 23:47:00

    RE: Hide/Show Column on Table

    Adding to this - a slicer selection should only display columns with data and hide the columns with no data.

    's profile image Profile Picture

    f29639aa 72ea-48aa-ae7e-e078be93b5ed on 05 Jul 2020 23:45:47

    RE: Hide/Show Column on Table

    Yes please!

    's profile image Profile Picture

    707b444f d3b0-4b84-a11b-e05cee0cd9e4 on 05 Jul 2020 23:39:00

    RE: Hide/Show Column on Table

    Need option to hide column but that column need to be used in sorting

    's profile image Profile Picture

    3a681cc2 02f0-4b69-b02c-ba7138857673 on 05 Jul 2020 23:38:47

    RE: Hide/Show Column on Table

    Surprised this wasn't part of power bi initially. If you have to link fields between tables it's junk we don't need to see.

    's profile image Profile Picture

    4ff0eb8b 82ef-41f5-975b-4a3ebc4d4cf5 on 05 Jul 2020 23:30:20

    RE: Hide/Show Column on Table

    We use id columns in Direct Query mode to drill through to another page.
    These id columns have to added value to the user so we want to hide them.

    's profile image Profile Picture

    59ab68e6 6cbc-4eb8-a964-84cfdd5b1b19 on 05 Jul 2020 23:27:31

    RE: Hide/Show Column on Table

    This seems like something that would be extremely useful....as would easily being able to reorder rows instead of using some complicated workaround.

    's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:21:35

    RE: Hide/Show Column on Table

    I am able to reduce the width of the column to a negligible size (but still noticeable with an exacting hover), but am unable to truly hide the column - is there a way to do this? Additionally I agree that, upon export, the hidden column should not be returned in the result set. Our clients have no interest in seeing our key values!

    's profile image Profile Picture

    8fb837b6 8629-43fd-9ac1-e9a20c7609ae on 05 Jul 2020 23:20:31

    RE: Hide/Show Column on Table

    '@jeyakumar - Can you please help us how are you able to hid the column in a table.