Skip to main content
Microsoft Idea

Power BI

Needs Votes

Hide/Show Column on Table

Vote (695) 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 (60)
's profile image Profile Picture

Liyasker Koilpitchai on 19 Dec 2023 06:45:41

RE: Hide/Show Column on Table

Adding the hide option will control the visibility for end user and at the same time can use hide column for default sorting.

's profile image Profile Picture

Chiara Baraldini on 11 Sep 2023 07:20:28

RE: Hide/Show Column on Table

This feature is very important as otherwise we have to duplicate a page in desktop layout, doing necessary edits/delections on columns in the new page and re-do the mobile layout on the new page. This also implies keeping the new page aligned with the original one manually (in case of introduction of new filters on data, for example) and this is not recommended.Chiara

's profile image Profile Picture

Elizabeth Philips on 24 Apr 2023 16:16:19

RE: Hide/Show Column on Table

This feature would be a game-changer.

's profile image Profile Picture

on 11 Apr 2023 18:18:32

RE: Hide/Show Column on Table

Often a drill through/down requires a "key" column for the related records. It would be great to be able to have a feature whereby you could add the key as a hidden column on visuals, purely so that they can be used when drilling through to related records/reports. At the moment you must show any fields in a visual where you want to drill from, and having to have a key column not only takes up space, but for the end user is meaningless.

's profile image Profile Picture

Svein Arne Hylland on 24 Feb 2023 08:42:56

RE: Hide/Show Column on Table

Would be nice to be able to have a hidden column in grid used to sort the grid - and still use it in tooltip like 'Days since last update'.

's profile image Profile Picture

Dhruv Sharma on 22 Jul 2022 02:23:28

RE: Hide/Show Column on Table

In a PBI Embedded scenario (app as a service), users want the ability to show/hide a column in a table.

's profile image Profile Picture

Sohini Sengupta on 16 Jun 2022 18:53:46

RE: Hide/Show Column on Table

We need to show count of text fields in the total bar, which again is not supported in Power BI. But somehow managed to create a measure that will show texts in the table and aggregation (count of rows in our case) in the total bar. But this has a limitation that it requires the original column to be in the table visualization, so it is required that we are able to hide it.

's profile image Profile Picture

Srujana Jammalamadaka on 03 Mar 2022 02:29:13

RE: Hide/Show Column on Table

We are exploring ways to alter a single table field output to display from cumulative sum to % values basing on text selection.And, the show and hide column feature is very useful. This feature is available in other tools like SAP WebI.

's profile image Profile Picture

Herbert Majuba on 08 Dec 2021 11:00:24

RE: Hide/Show Column on Table

I needed to sort a table by calculated column but did not want to show the column because it took up space

's profile image Profile Picture

Christopher Wye on 23 Nov 2021 11:48:27

RE: Hide/Show Column on Table

I think the ability to hide a column in a visual is basic functionality, especially if you want to create dynamic measures to use the hidden column for filtering rows!

Merged Idea (1)