The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
can you hide the slicer once user has selected the input in power bi? or is it possible to remove the slicer before downloading the report ?
I have a user selection slicer on the dashboard I dont know if i can remove it while downloadinh the report in pdf format
Thanks for the information , I got the information through AI that
you can try a workaround using the following steps:
Create a Duplicate Page: Duplicate the page that contains the slicer you want to hide after the user makes a selection.
Modify Duplicate Page: On the duplicated page, remove the slicer or adjust its visibility as needed.
Create a Button: On the original page, add a button that will navigate the user to the duplicated page when clicked.
Bookmark the Selection State: Create a bookmark for the original page that captures the slicer's selection state.
Set Button Action: Assign the button on the original page to navigate to the duplicated page and apply the bookmark created in the previous step.
Export to PDF: When you export the report to PDF, use the duplicated page with the modified slicer visibility.
This approach leverages bookmarks and navigation to create two different versions of the same report page—one with the slicer visible for interaction and another without the slicer for PDF exporting. When a user interacts with the slicer and clicks the button, they are directed to the page without the slicer, which can then be exported to PDF.
though I want to know if this workaround helps coz i was not able to try it.
Great! Try it out, and add some feedback to this post. Good luck.
This, perfect! 👌