Create a slider with column that has a list to filter a another table.

[jaracad]

Hello, 

I need some help on creating a slider using a column that has a list of individual words (keywords) in one table that I want to use to create a slider/filter to go an search if this word on the rows from a column in another table and bring the information according to this?

Table 1

Column for slider

a

b

c

d

e

f

g

Table 2

Column with data

b, d, a

e, f

a, b, c

g, e

b, d, c

f, c

a, c, e

Thanks in advance,

[lbendlin · Accepted solution]

You can use measures as visual filters. BUT you must decide if your slider allows multiple selections, or is single select. For Multi select you need to decide if all conditions must match (ie strings containing "a"  and "b") or if it is enough for one of them to be true (ie strings containing "a" or "b")

 

See attached for a version that allows multi select

or

[jaracad]

Thank you so much. I ended applying another solution by duplicating tables and creating relationships but this solution looks so much clean for the model. I will use it!

[CoreyP]

@lbendlin solution will certainly work. Another option, if you don't need to display the list of keywords for some reason, like perhaps there are a ton of possible words in the dataset, you can import the custom visual Text Search, which is just a standard search box where a user can type a keywork and search the field you want.