Cascading Parameters Not Auto-Refreshing After Multi-Select in PowerBI Report Builder

[Chetan40]

Hi Team,

I am facing an issue with cascading parameters in PowerBI Report Builder where multi-select parameters do not automatically trigger the dependent/child parameter refresh until the user manually clicks outside the dropdown.

---

Scenario:
- I have a report with multiple cascading parameters (e.g., Region → Category → Sub-Category).
- Each parameter has multi-select enabled.
- When a user selects multiple values from the parent parameter (e.g., Region), the child parameter (e.g., Category) does not refresh automatically.
- The user has to click outside the dropdown first to "commit" the selection, and only then does the cascade trigger.

---

Questions:
1. Is there a native way in Report Builder to trigger cascading refresh automatically while the multi-select dropdown is still open?
2. Is this a known limitation, and is there a recommended workaround?
3. Does Power BI Paginated Reports handle this any differently ?

Any guidance or workarounds would be greatly appreciated!

Thank you.

[v-hashadapu]

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.

[v-hashadapu]

Hi @Chetan40 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[v-hashadapu]

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