How to show/hide filters based on True/False

[MarshalSK]

Hi Folks, Need your assitance to achieve below requirement.

I have 3 filters - Filter1, Filter2, Filter3.

If I select any value in Filter3:

• it should show only Filter1 and hide Filter2

else

• it should show only Filter2 and hide Filter3

[Anonymous]

Hi @MarshalSK 

Unfortunately the power bi doesn't support the feature currently. Just as @shravanreddy133  posted, the bookmark can be a alternative workaround, or maybe you can try field parameter, you can add 3 measures to realize the 3 filters' feature and selected by slicer like this:

Or maybe you can submit your ideas through Microsoft Fabric Ideas. It's a place for users to share and discuss improving the product.

Here is the link of the Microsoft Fabric Ideas:

Home (microsoft.com)

Best Regards

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

[shravanreddy133]

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.

[MarshalSK]

@shravanreddy133 Thanks for the response. It works fine with button but not based on selection.