Look up a list of values using Dashboard filters

Sometimes instead of manually picking from a drop down you want to use a lookup list of values - this is helpful when the values is large and you have some external source of the values like in excel column.

You can configure filter setting to enable manual value mode:

This will provide the users with “Enter Values” as a new option in the filter:

Note: each distinct value needs to be on a new line.


The same option exists in the visual editor screen.

Drag the column you want to filter and place it into the “Filter” shelf. Then in the dialog that appears go to “Set Values” and paste your rows of values.