Forum Discussion

tiagopardo's avatar
tiagopardo
Frequent Visitor
2 years ago

Dropdown selection that doen't allow empty, apply filter button that also navigate to other pages

Hello,   Here's what i need to do: A page (refered as page 1)  that only has a dropdown filter for companies and a button for applying the filter. As the user clicks on this button, I need it to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, tiagopardo 

According to your description, you want to implement a page jump with a button that forces the slicer in Page1 to select a company when jumping.
1. You can make the drop-down slicer radio (if possible, the radio button will be selected automatically), create a Bookmark in Page2, and bind the button created in Page1 to the Bookmark to accomplish your needs;
2. If the radio does not meet your needs, you can create the exact same slicer in Page2 and Page1, bind the two slicers as synchronized slicers; choose any option in the slicer, create a Bookmark in Page2, bind the state of the option, and if the slicer in Page2 affects your visual effect, you can hide it (remember to update the BookMark)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

tiagopardo's avatar
tiagopardo
Frequent Visitor
2 years ago

Hello friend,

Thanks for your reply.

 

In this case, can't use the drop-down slicer radio because there are too many companies to select.

 

In your solution, if i got it right, the user would be able to dont select any company in the first page and click in the button that navigates to the second page. Is that correct? If so, that is right what i want to avoid. I want the user to be able to change through companies but never leave the company selection blank before applying filter.

 

Is there a solution for that?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, tiagopardo 

     

    If you try my method, you'll see that regardless of whether the user selects the slicer in Page1 or not, when he clicks the button to jump, the slicer in Page1 selects a value, and there is no empty selection.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum