Forum Discussion
Query Parameter is not refreshing
Hello, I have two Query Parameters that are for the user to pick a country name, then to pick a state/region from the selected country. If I change one parameter (the country selection), the state/...
jspowerbi wrote:
Hello, I have two Query Parameters that are for the user to pick a country name, then to pick a state/region from the selected country. If I change one parameter (the country selection), the state/region parameter values do not refresh unless I click OK and reopen the edit paramter prompts. Then the region/state list is updated with the previously selected country. Is there any way to force the refresh of a parameter without closing / reopening the edit parameter dialog?
So the second parameter is a parameter valuing "Query" and the query is filtered by the first parameter, right? In this case, AFAIK, it is not possible to do the auto refreshing. You'll have to refresh the second parameter in the way you mentioned.