Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Hi @Anonymous
No, you can not control visual visibility with slicer
Only with bookmarks
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
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.