Dataset/Analysis parameter filter does not reflect filtered dataset results

The behaviour I am seeing with a DataSet/Analysis parameter filter is clever, but not what I want.

I have this Direct Query dataset:

I have this analysis with a parameter filter linked to the “test” field in the dataset:

The filter parameter is correctly passing through to the dataset and the results are now excluding “That”.

What I would now like to happen is that when I click “Refresh” on the Control, the filter also only shows “And” and “This”.

Instead, what it does is to reset the parameter to default before re-running the query and updating the items in the dropdown. I know this is the case, because if I add a “#” to each item in the dataset in another window, and then refresh the filter in this window, the list items are updated, but not filtered.

Can anyone think of a way to achieve the result I am looking for. The point of this is to implement a “needle-in-a-haystack” filter where I keep adding to the filters and reduce the “noise” that I have to look at.

I should add …

This query is simplified. The actual dataset implements a subquery that counts the number of filter “hits” per entity and checks that it matches the number of items in the filter.

That part works fine.

The issue is how to have the filtered list reflected in the dropdown.

Hi @Jeremy_Likezero,
Apologies from the community for missing your initial posting. A quick note on that, when you add an additional comment/response to a topic, it gets removed from the ‘unanswered’ and ‘new’ sections of the community making it hard to find for others to assist. I would suggest editing your initial post as opposed to adding a second comment to avoid this from happening in the future!

In regards to your question, there’s no great way to limit the values being returned in a parameter without choosing the default value(s) when setting up the parameter. Unfortunately, there’s no built in way to limit the values returned in this manner. I’ve seen a few other similar requests for parameter value limitations so I’ll mark this as a feature request to promote visibility to the support team.

Let us know if you have any additional questions