Couldn't get the filter on the sheet to work as needed

[TK2895]

I am trying to create a sheet specifically for few markets from my dataset. I am normally filtering my data for the markets as shown here.

I wanted to add this filter to the sheet, which I did.

Now, I want to display only the filtered markets in my sheet. But when I do that by selecting Specific values option under Format control settings, the filter is not working as intended.

I mean, if I uncheck one market from the filter dropdown list, it is disappearing from the dropdown, which is not I want. I want to show only specific markets based on initial filtering and I want to use dropdown multiselect without losing the market values from the dropdown. I tried a few things by using Format control options but it is the same result.

I have unchecked a couple of items from the list and they have disappeared here.

Can someone please help here Thanks in advance!

[Xclipse]

Hi @TK2895, I ran into a similar issue while on authoring mode, once published as a dashboard, it started working.

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

If that does not work, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena