Author Details

avatar-teacher

Evolvous

We are a team of tech enthusiast and this section is where we love to share our experience and our knowledge. We try our best to help you understand technical topics by giving you live instances of how-to’s, guides, tips, FAQ’s and troubleshoots.

If you like it or have questions, do share your feedback in the comments section below.

Power BI – Show/Hide Section

Introduction Power BI – Show/Hide Section

Let us take one scenario for this blog. If you want to show/hide some section on the report, how can you achieve it? The answer is using a bookmark. Let us see in detail with a simple example. 

Steps: 

1. Open Power BI Desktop and insert any visualization and create a simple report. I have created a bar chart from the SharePoint list. It looks like  

Power BI – Show/Hide Section - Evolvous

2. Next, insert the Right Arrow button on the report using Insert Menu -> Buttons -> Right Arrow 

 Show/Hide Section right arrow

After inserting the button, adjust the height/width of it to look like the below image.

3. I am inserting Slicer to apply the filter on the chart, and I don’t want this Slicer to occupy space on the report page. It should show/hide when I click on the button. 

So, insert the slicer control on the report and assign some field to it using which you want to filter the report data. 

Next, insert the Left Arrow button on the report using Insert Menu -> Buttons -> Left Arrow. 

4. Now it’s time to create bookmarks. First, show the bookmark pane (using View -> Bookmarks) and selection pane (using View -> Selection) in Power BI Desktop. 

5. Add two bookmarks and rename them to “Show Slicer” and “Hide Slicer” as shown below image. You can give any suitable name to bookmarks. 

 

6. Now set the controls to bookmarks. 

 – Select the Right Arrow button from the Selection Pane.  

– Keep it visible and hide the Slicer and Left Arrow button.  

 – Click on the “Show Slicer” bookmark. Click on 3 dots of this Bookmark from the context menu, uncheck data and click on “Update” as shown in the below image. 

7. In the same way,  

 – Select Slicer and Left Arrow button 

 – Keep it visible and hide the Right arrow button. 

 – Click on the “Hide Slicer” bookmark. Click on 3 dots of this Bookmark from the context menu, uncheck data and click on “Update” as shown in the below image. 

8. Next, select the Right button from the selection pane, and then in the visualization pane,  

 – Set Action to On  

 – Select Bookmark in the Type dropdown  

 – Select “Hide Slicer” in the Bookmark dropdown. 

Power BI – Show/Hide Section - Evolvous

9. Select the Left button from the selection pane and then in the visualization pane,  

 – Set Action to On  

 – Select Bookmark in the Type dropdown  

 – Select “Show Slicer” in the Bookmark dropdown. 

Power BI – Show/Hide Section - Evolvous

That’s it; now, you can save and publish the report and check how it works when you click on the Left and Right arrow buttons. 

I have attached a video on how it looks. 

I hope you found this blog useful. 

Power BI services Microsoft Gold Partner - Evolvous

_______

Written by Priyanka Patel

Priyanka is Senior Software Developer at Evolvous Limited – specialists in Microsoft Technologies.