Hide columns or table using Slicer / buootn

[RaffiKouzoudj]

Hello!

I have around 10 tables and each table having different column headers/columns. The dashboard has slicers and based on the slicer value I want to display 1 of the tables and hide the other 9.If the slicer doesn't work, can I hide/unhide buttons based on the slicer values? In that way, i use bookmarks with the button to show the tables? Let me know if the above is clear and thank you for your reply.

[v-robertq-msft]

Hi, @RaffiKouzoudj 

According to your description, you want to show/hide the bookmark buttons on your report page based on the selection of Slicer. There’s no feature to completely hide a button in Power BI, but you can set the font color and icon color to white or black based on the selection of slicer, you can take a look at my method and find if it can achieve your requirement:

1. I create a table for the Slicer:

2. I create three measures in the table:

Page 1 =

IF(SELECTEDVALUE('Slicer'[Page])="Page 1","Black","#FFFFFF00")

Page 2 =

IF(SELECTEDVALUE('Slicer'[Page])="Page 2","Black","#FFFFFF00")

Page 3 =

IF(SELECTEDVALUE('Slicer'[Page])="Page 3","Black","#FFFFFF00")

3. I created three bookmark buttons for each page and set the title font color and icon color of these buttons like this:

Then do the same thing for the other two buttons, and create a slicer to place [Page] column.

And you can get what you want, like this:

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result with some sample pictures.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RaffiKouzoudj]

Thank you for your quick reply, below you will find the elaboration of my dashboard and what I'm trying to achieve.

Step 1: I have the slicer (2nd pic) where I have listed my categories "Basic Assistance", "Child Protection", "Educatoin"....

Step 2: Then I have created tables for each category and linked them to buttons. So The user click on the slicer and selects "Basic Assistance" category. All the visuals on the report will be updated. However, for the user to see the specific "Basic Assistance" category data. The user needs to Click on the "Basic Assistance" button. Here, using the bookmark only the "Basic Assistance" table will be visible and all other tables related to other categories will not be visible.

The way forward, I want to remove the buttons and instead link the table visibility directly to the slicer! If that is not possible, I want to use one table and dynamically hide/unhide my static column on the table or matrix

hope the above elaborate my requirement. thank you.

[v-robertq-msft · Accepted solution]

Hi, @RaffiKouzoudj 

According to your description, I guess that the “Filter” type of interaction between Power BI visuals may help you to achieve your requirement of using one table to dynamically hide/unhide your static column on the table or matrix.

You can follow this document:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@RaffiKouzoudj , check if calculation groups can help

https://www.youtube.com/watch?v=vlnx7QUVYME

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[RaffiKouzoudj]

Thank you Amit for your quick reply, the calculation groups might work however my table headers are not calculated fields. they are static columns from the table. Not sure if we have another way of doing it. I have used bookmarks with buttons however our end users were confused. Since they are using the slicer and then they need also to click the specific button! too many clicks 🙂