CODEWITHSUNDEEP
powerbipowerbi-desktoppowerbi-custom-visuals
Wanna Coffee
Wanna Coffee

Reputation: 2798

Show/Hide column in Power BI Table/Matrix visual

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).

Upvotes: 3

Views: 49831

Answers (3)

SKC
SKC

Reputation: 19

This is now available in Power BI with preview feature "Field Parameter". Check the May 2022 update.

Upvotes: 1

Mike250
Mike250

Reputation: 95

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.

Upvotes: 4

vignesh subramanian
vignesh subramanian

Reputation: 36

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!

Upvotes: 1

Related Questions