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:
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
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 ‘INCLUDES’ instead. This will have the same affect as ‘contains’ in your instance.
Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.
Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Were you able to find a solution yourself in the meantime? Please help the community by following up in general within the next 3 business days!
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 string. If you were to put in an additional string sequence, it would no longer match your initial request. It does not have the ability to hold on to prior string requests for your filtering.
I can mark this as a feature request to promote visibility to the support team.
