The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I am using filters in the hiding filter pane (filter on this page), also, I have created a button type to clear all filters, for example, If I click any visual to filter any other graph to see data, then I just click the button to clear all filters but it is affecting the filters I created in the hiding filter pane (filters on this page). What should I do, If I click the button(clear all filters) should not affect any other hiding filter pane that I created?
Solved! Go to Solution.
Hi @AtchayaP ,
If you set the slicer to a distinct value people will only be abble to select one value from the slicer, also to make it a cleaner report what I ussualy do is to create a button with the filters and using bookmarkls I show and hide the slicers, or place it on a principle page so users must go back and select .
Pls refer the following article and check if it is helpful,and if question still not solved,could you pls share your pbix file and output result ,remember to remove confidential data:
https://community.powerbi.com/t5/Desktop/Hide-Clear-filter/td-p/1325541
Best Regards
Lucien
Hi @AtchayaP ,
If you set the slicer to a distinct value people will only be abble to select one value from the slicer, also to make it a cleaner report what I ussualy do is to create a button with the filters and using bookmarkls I show and hide the slicers, or place it on a principle page so users must go back and select .
Pls refer the following article and check if it is helpful,and if question still not solved,could you pls share your pbix file and output result ,remember to remove confidential data:
https://community.powerbi.com/t5/Desktop/Hide-Clear-filter/td-p/1325541
Best Regards
Lucien