Show/Hide column in Power BI Table/Matrix visual

Question

Is there any possibility to show or hide the column in Table/Matrix visual in Power BI report by user dynamically?

For Example, I have a table view with columns COLUMN-1, COLUMN-2, COLUMN-3. Now I may have filter drop down to list all the column headers, so based on user selection (Multiple selections) Table view should get adjusted to show column values.

Since Power BI was developed based on Excel, curious to know if we are having Hide/Show column based on any condition or available in visual by default (Maybe by right-clicking on column header then show/hide it).

Solution 1

You can do this with the following workaround:

• Create your page with the table showing both columns.
• Create a bookmark, uncheck "Data"
• Duplicate the page and remove the column you want to conditionally hide. Set the page as hidden.
• Create a bookmark, uncheck "Data"
• Add a button to the first page pointing to the 2nd bookmark
• Add a button to the second page pointing to the 1st bookmark
• Ensure your slicers are synced

The end user experience is they will feel like they are conditionally hiding and unhiding the column.

A bit crap and a lot of extra work but I have it working well in my implementation.

Solution 2

Currently it is not possible to hide columns in visual based on slicer selection, there is an idea about this issue, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19435267-conditional-visibility-of-a-visual-based-on-slicer

Thanks!

Comments

[Wanna Coffee]

Yes, I did... But looking for if there are any other workaround

[Justyna MK]

Good workaround. You can actually do this trick on the same page, i.e. duplicate the table and adjust each to show/hide relevant columns. Then have only the first table shown (use "Selection" view) - assign it to the 1st bookmark, and then have only the second table shown - assign it to the 2nd bookmark.

[Wanna Coffee]

@Mike250: Appreciate your answer for this post.!