Forum Discussion
Hide visuals based on slicer selection
Hi Experts,
Please let me know, how can we achieve this in Power BI.
I have two slicers in the report.
1. Accomodation type (dropdown slicer) - General, Delux
2. Facilities(dropdown slicer) - Air conditioned, Heating, Internet
The requirement is, if user has selected Accomodation type = Delux, then user should have Facilities slicer vissible to select further choices. But if user has selected Accomodation type = General , then the second slicer, Facilities should be invisible on the report.
Thanks.
5 Replies
Tahreem24Super User
You can accomplish this requirement with the help of Selection Pane and Bookmark. Then Apply this bookmark on Button.
Thanks Tahreem24 and Anonymous for your reply.
We can not include buttons in the report. That is why can not go with the bookmark and selection pane.
Thanks and Regards.
Anonymous ,
You can use buttons for showing or hiding visuals.
https://docs.microsoft.com/en-us/power-bi/desktop-buttons
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Your seconds slicer of facility will get automatically filtered and later it can be used for filteration of data.
I hope that helps.
Regards,
Kaushlendra Mishra
- az38
Community Champion
Hi Anonymous
No, you can not control visual visibility with slicer
Only with bookmarks
