Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I was wondering if I could create a button that wil filter the report if clicked on, for example if I click on it it will hide a specific coulmn in the report. I did something similar using switch function, but it only works on measures.
Thank you
Solved! Go to Solution.
Hi @Manar,
Current power bi not contains any similar actions to dynamic hide columns based on filter/slicer operations, I'd like to suggest you submit an idea for these requirement.
Regards,
Xiaoxin Sheng
A workaround is to use the bookmark feature. Create a second table which doesn't have the column you wish to hide, and use buttons linked to the respective bookmarks to toggle between visuals.
I use the bookmark feature for all kinds of functionality, ranging from report navigation to clearing filters. It makes Power BI very versatile IMHO.
Proud to be a Super User!
Paul on Linkedin.
A workaround is to use the bookmark feature. Create a second table which doesn't have the column you wish to hide, and use buttons linked to the respective bookmarks to toggle between visuals.
I use the bookmark feature for all kinds of functionality, ranging from report navigation to clearing filters. It makes Power BI very versatile IMHO.
Proud to be a Super User!
Paul on Linkedin.
Great Thank you!
I was wondering if I could create a button that wil filter the report if clicked on, for example if I click on it it will hide a specific coulmn in the report. I did something similar using switch function, but it only works on measures.
Thank you
Hi @Manar,
Current power bi not contains any similar actions to dynamic hide columns based on filter/slicer operations, I'd like to suggest you submit an idea for these requirement.
Regards,
Xiaoxin Sheng
Hi I was wondering if it's possible to add a button and filter a report based on that button action, for example when I click on the button it will hide a column in the report. I've done something similar with swithc function but it only works with measures.
Thanks