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