Forum Discussion
Add Mutiple Filters and Execute Them
Are you talking about Filters here or slicers? Slicers don't work that they, they dynamically filter as you make your selections. I also believe that Filters you have to apply them as you go. I do not know of a way around any of this currently other than perhaps this.
Create a page with your slicers and only your slicers. Duplicate this page and sync slicers. Add your visuals to this second page. Go back to the first page and add a button that is a link to your second page. Now, the user will select the slicers and then when they are finished hit the button and will be transported to the second page, which has all of the slicer selections sync'd over to it.
I though that was another way to do it, i still gona try it but probably will work. In my case everything needs to be in one dashboard so more pages wont solve the problem, i think i will leave as 4 slicers and the user selects what he want. By the way do you know how can i make turn blank the visuals (graphics ) that are not being used? For example i have a slicer with 5 (Datasource) and when i select one of them only show the information about that datasource selected and the others just show with no data (only background black) is there a way to make them invisible/blank when they are not selected ??
- Greg_Deckler7 years agoCommunity Champion
ooooo, just thought of another way to do it. Use Bookmarks and tie your button to a bookmark that displays the visuals versus them being initially hidden.
- v-yulgu-msft7 years agoMicrosoft Employee
Hi atonidas,
In Power BI, it is not supported to insert an extra button to apply slicer filters. Besides, to conditionally show/hide visualizations based on slicer selection is not supported, either.
Regards,
Yuliana Gu