Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hari27pn
Frequent Visitor

I want to hide/show buttons based on dropdown slicer selection

I have my Year slicer which currently contains two years - 2023 and 2024. Now I want to create a two buttons one which would lead to 2023 Table page and other that leads to 2024 Table page using page navigation.

Now I want if the user selects 2024 from the Year dropdown slicer, then only "Go to Table - 2024" button should appear. And if user goes to 2023 using slicer, "Go to Table - 2023" Button should appear.

Is there any way to do this?

2 ACCEPTED SOLUTIONS
MattAllington
Community Champion
Community Champion

This may help you.  You won't be able to use the exact approach because you can't cover the button, but you may be able to use the same technique to make the button transparent 

 

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

Ritaf1983
Super User
Super User

Hi @hari27pn 
I recorded screens of some workaround and put them here :
Link to screenshots 

And sample file here:

Sample pbix 

Please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @hari27pn 
I recorded screens of some workaround and put them here :
Link to screenshots 

And sample file here:

Sample pbix 

Please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
MattAllington
Community Champion
Community Champion

This may help you.  You won't be able to use the exact approach because you can't cover the button, but you may be able to use the same technique to make the button transparent 

 

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.