Add Configurable Option in Dashboard Filters to Restrict Searchable Filter Values to only the ones that exist in the Dataset

What is the problem or goal the end user is trying to solve or accomplish?

The customer finds the current behavior of dashboard filters confusing. When users search for a value in a filter, they can see and select values that are not present in the dataset, which can lead to misunderstanding. For example, selecting such a value results in no data being displayed, but this behavior is not intuitive and can be misinterpreted as a bug.

How are they solving it currently?

The customer is working around the issue by manually understanding the limitations of the current filter behavior. However, they feel that this behavior should be configurable rather than enforced, so it aligns better with their workflow.

What is the recommended solution by the Customer?

The customer suggests adding an option to configure the filter behavior. Specifically, they would like the ability to restrict filter searches to only values present in the dataset. This would make the filter behavior more intuitive and reduce confusion for end users.