• Saravana

Show and Hide Filter using Buttons in Power BI

#Analytics #PowerBI #BusinessIntelligence #Reporting #Microsoft #AforAnalytics #RealEstate #Consulting




Do you want?


Keeping slicers in the Power BI Report occupy plenty of spaces. Do you want to know How to Hide and Show the slicers in Power BI using a trick?




Business Function


Business User doesn't want to see the Drop downs and other filters in the report. Business user wants to have a Button to enable them to show or hide the slicer panel.


Technical Function


We needs to create several steps to achieve this trick


Step 1: Create a Button in Power BI with formatting required for the project.

Step 2: Create a slicer with data field which users wants to see in the report.

Step 3: Keep the Slicers on the place where you want to pop up in the report when Filter button is clicked by the user.



Step 4: Create a bookmark here to achieve this trick

a. Keep slicers in the respective place and add New bookmark names "Filter Horizontal Pop".



Step 5: The last and final step is to link the Button and Bookmark to achieve this show and hide filter illustration.

a. Click the button and under the Action drop down in the Visualization pane.

b. Change the Type of Action to Bookmark c. Select the Bookmark you created for Filter Horizontal Pop up in the Bookmark drop down.


AforAnalytic helping Fortune 500 companies to build Power BI Reports and Providing solution to complex problem in the real world. Thanks for Reading.. There is a Bonus for you.

Bonus


Do you know there is a trick to switch Visualizations in Power BI Reports using the Bookmarks and Buttons.


You can read about it more here Switch Visualization using Buttons

Shout out to Guy in a Cube for showcase this option

Click here to see his Power BI Bookmark,Selection and Toogle



Conclusion

Every tool in a Business Intelligence Space has a limitation of some sort. No Matter, there will be one Alternative Solution where you can find or company like AforAnalytic can able to help you out to reduce the time spent on Research & Analysis by providing Solution to problem in Very less time. What do you think? Drop your comments below

A for Analytic

  • Facebook Social Icon
  • Twitter Social Icon
  • LinkedIn Social Icon
  • Instagram Social Icon

Chennai, Tamil Nadu, India

©2018 by A for Analytic