Forum Discussion
Button to hide/show specific page
- 2 years ago
I assume it's not possible
Yes, it's possible to achieve the functionality you described using bookmarks and buttons in Power BI. Here's a general outline of how you can implement it:
1. **Create Bookmarks**: Start by creating bookmarks for each page of your report, including one for the scenario where the specific page is hidden and one where it's shown.
2. **Hide Pages**: By default, hide the specific page you want to give the user the option to show or hide.
3. **Create Buttons**: Create buttons or slicers that the user can interact with to toggle the visibility of the specific page. For example, you can create a button labeled "Show Page X" and another labeled "Hide Page X".
4. **Set Button Actions**: Set the actions for these buttons to apply the appropriate bookmark when clicked. The "Show Page X" button should apply the bookmark where the specific page is shown, and vice versa for the "Hide Page X" button.
5. **Generate PDF**: When the user is ready to generate the PDF, they can interact with the buttons to show or hide the specific page as desired. Then, they can use the built-in PDF export feature in Power BI to generate the PDF with the current report state.
By following these steps, you provide the end-user with the ability to show or hide a specific page in the report using buttons, and they can generate the PDF accordingly. This approach offers flexibility and customization while leveraging Power BI's built-in features.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
- rafal72 years agoFrequent Visitor
Hi,
Thank you for your response.
But I have question for step 4. I don't know how to set it up. It seems like bookmarks don't store the state of pages either their are shown or hidden.