Forum Discussion
Cascading Parameters Not Auto-Refreshing After Multi-Select in PowerBI Report Builder
- 3 months ago
Hi Chetan40 , Thank you for reaching out to the Microsoft Community Forum.
This is expected behaviour in Report Builder / SSRS and is effectively by design. Cascading parameters only refresh after the parent parameter value is committed, not while the multi-select dropdown is still open. In multi-select scenarios, the selection isn’t applied until the dropdown loses focus, for example, when the user clicks outside, which is when the dependent parameter query is triggered.
There is no native way to force real-time refresh while the dropdown is open. Power BI Paginated Reports behave the same way since they use the same underlying SSRS (RDL) parameter framework. The usual approach is to guide users to close the dropdown after making selections or simplify cascading dependencies where possible to reduce interaction friction.
Use cascading parameters in paginated reports - Power BI | Microsoft Learn
Add Cascading Parameters to a Power BI Paginated Report - Power BI | Microsoft Learn
Report Parameters in Power BI Report Builder - Power BI | Microsoft Learn
Hi Chetan40 , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.