Hi team, I got an weird error when with parameter. I have a field in the dataset named “period”. I created a parameter named [PPeriod1] with drop down list to allow users select multiple values for this field. I have a calculated field named [cf_Period1] with the formula: ifelse(in({period},${PP…

Hi @baduong , This is a limitation with QuickSight and unfortunately, there’s no real way to build a work around…Multi-Select Parameter’s do not allow you to use the ‘Contains’ condition. The ‘contains’ condition can already return multiple values as it looks for fields that contain the inputted str…

Hi @baduong , can you show us how the param and the control are configured? Have you tried to directly link the possible value of the multi-select control to the dataset, or have you entered the data manually? [image] Thank you, Andrea

[image] andrepgn: Have you tried to directly link the possible value of the multi-select control to the dataset, or have you entered the data manually? Hi, sorry for the delay. Here is the configuration [image]

Hi @baduong , do you have any other filters in the same dashboard? Or calculated fields? Any other “not standard” config? Just to try and replicate the issue :slight_smile: Andrea

Hi, there is nothing not standard.

Hi @baduong , Following up here as it’s been awhile since last communication took place on this thread; are you still working on this or were you able to find a work around in the interim? To my understanding, the ‘CONTAINS’ logic does not work with a multi-select parameter, you’ll have to use ‘INC…

Hi, The thing is in the formula, it doesn’t have CONTAIN function. Its content: ifelse(in({period},${PPeriod1}),‘Compare From’,‘’)

Hi @baduong The issue appears from the filter on the visual. There is a old post with similar issue see if it helps [image] Multi-select dropdown parameter doesn't allow CONTAINS filter Q&A The error message you’re encountering indicates that the multi-select…

Hi @baduong , Did the last response assist further with your issue?

No, it’s not. I still have to place the condition in filter area

Filter - "CONTAINS" filter on column <calculated field>

Q&A

Giridhar.Prabhu October 30, 2025, 2:14pm 9

Hi @baduong

The issue appears from the filter on the visual. There is a old post with similar issue see if it helps

Topic		Replies	Views
Multi-select dropdown parameter doesn't allow CONTAINS filter Q&A quick-sight	4	1599	August 18, 2024
Strange “CONTAINS” filter error with multi-value parameter (but I’m not using CONTAINS) Q&A analysis , filters , parameters , error , quick-sight , dashboard , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	98	March 24, 2025
Multi-value parameter support for "Contains" type of filter condition Q&A feature-request , quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	1	959	December 20, 2023
Multiselect Parameter, error when giving parameter input in calculated field Q&A parameters , quick-sight , filters-controls-and-parameters , calculations	3	490	July 19, 2023
Filter by a String separated by commas / "Contains" function argument type Q&A analysis , filters , parameters , quick-sight , calculations , Business-Intelligence-Engineer	3	125	June 2, 2025

Filter - "CONTAINS" filter on column <calculated field>

Related topics