How to show/hide filters based on True/False

Hi,

Workaround for this is to create bookmarks in power bi desktop.

1. Create two bookmarks: one for the state when Filter1 and Filter2 are visible, and another for the state when Filter2 and Filter3 are visible.

2. Add buttons to your report for selecting values in Filter3 and assigning bookmarks.

3. Set up bookmarks to control the visibility of filters:

   a. Navigate to the "View" tab in Power BI.

   b. Click on "Bookmarks" to open the bookmarks pane.

   c. Create a new bookmark for the state when Filter1 and Filter2 are visible. Make sure to select only Filter1 and Filter2, and hide Filter3.

   d. Create another bookmark for the state when Filter2 and Filter3 are visible. Select only Filter2 and Filter3, and hide Filter1.

4. Add buttons to your report canvas:

   a. Go to the "Home" tab in Power BI.

   b. Click on the "Button" control under the "Buttons" dropdown.

   c. Place the buttons on your report canvas, labeling them appropriately (e.g., "Filter3 Option 1", "Filter3 Option 2").

   d. For each button, go to the "Action" section in the "Button Visualization" pane, and select "Bookmark" as the action type. Choose the corresponding bookmarks created in step 3.

5. Now, when users click on the buttons, it will toggle the visibility of Filter1, Filter2, and Filter3 based on your requirements.