Forum Discussion
De-selction not working in Binded Query Parameter filter selection
- 1 year ago
Hi kushanNa ,
Based on your explanation and the shared screenshots, it looks like you're encountering a known quirk in Power BI when using bound parameters with slicers—especially with the "Select All" and deselection behavior. The issue you're seeing, where deselecting an item ends up re-selecting it or resetting the selection altogether, often arises when the parameter is tied to dynamic M code or native SQL queries. This happens because Power BI re-evaluates the parameter whenever slicer selections change, and if your default value is set to something like "SelectAll", it can force the slicer to revert to that default when it loses context.To address this, a better approach might be to avoid using "SelectAll" as a default and instead handle empty selections more gracefully by checking for null or empty lists in your M logic. You could also consider creating a simplified test file with just one slicer and one table to isolate whether the issue is visual or data model-related. If the issue persists even in the simplified version, it confirms that it's tied to how bound parameters behave during state transitions. And yes, if this functionality is critical to your report and disrupts usability, submitting it as a feature request to the Power BI Ideas portal would be a good move to bring attention to the product team.
Hi rjgupta5757,
Thank you for reaching out in Microsoft Community Forum.
Thank you rohit1991 , kushanNa for the helpful response.
As suggested by rohit1991,KushanNa., I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.