How to create a Searchable table

Q&A
, , ,
1

I created a table, but I’d like each column to be filterable or searchable for users interacting with the dashboard. I attempted to enable this by adding a Filter Action under Interactions in the Properties panel, but it doesn’t seem to be working.

2

Hello Karina,

First of all Welcome to the Quick Sight community !

With what you are looking for you may have the below option

  1. Using Filter Controls (Recommended method):
  • In the analysis, select “Add” on the top menu bar
  • Choose “Filter Control”
  • Select the field/column you want to make filterable
  • Choose the type of filter control (dropdown, list, text field, etc.)
  • The filter control will appear above your visual and users can interact with it
  1. Using Custom Actions (Alternative method):
  • Select your table visual
  • Go to the “Actions” menu in the visual’s properties panel
  • Click “Add action” and select “Filter action”
  • Configure which fields trigger the filter
  • Select target sheets and visuals that should be affected

NOTE - Custom Filter Actions in Quick Sight are primarily designed to work between different visuals or sheets - they require at least two visuals to function properly. If you only have a single table visual, Custom Filter Actions won’t work effectively.

For a single table visual, you should use Filter Controls (Method 1) instead:

  1. Use “Add” → “Filter Control”
  2. Select your columns
  3. Choose appropriate filter types (dropdown, text, etc.)

Hope this gives some idea.

Cheers,
Deep