Forum Discussion

jspowerbi's avatar
jspowerbi
Advocate II
9 years ago

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/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?

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    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?

    jspowerbi

    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.