Test Search box - multiple tables and visuals

[hgromek]

I am pulling in 5 different SP lists, that are in visual tables on a page (name & Weblink). All have common naming conventions - for example "BLUE" could show up in all different tables. I want a TEXT FILTER that will search all different tables on the page and return records with BLUE in the name. Right now - they will need to search 5 different tables, not very user-friendly.  

I tried the TEXT SEARCH visual from Microsoft, but that is limited to 1 column on one table. 

Any ideas on how to execute this? Sorry I know I haven't described it well, any advice is appreciated. 

[Anonymous]

Hi @hgromek ,

I have built a data sample for test:

Table1:                                                     Table2:

   

Based on your description, it seems that you want to filter all tables by a single filter ,right?

If so, I'd sugget you firstly create a new table for slicer 

And then create measures as flags to visual-level filter as shown below:

(Since measures could only be applied to visual-level filter, we need to create multiple measures)

Measure1 = IF( CONTAINSSTRING(MAX('Table1'[Weblink]),SELECTEDVALUE(ForFilter[Value])),1,0)

Measure2 = IF( CONTAINSSTRING(MAX('Table2'[Weblink]),SELECTEDVALUE(ForFilter[Value])),1,0)

Now when select a value in slicer, all visuals could change together.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hgromek]

Thank you for the suggestion, but my list is more like 20,000 items names that could what any common text so I can't create the Filter Table. 

[AlexisOlson]

I doubt this is currently possible.

Generally, if you have multiple tables with the same naming, then it often makes sense to combine them. This usually makes modeling easier and would allow you to search in just one table.

[hgromek]

I am trying to append all the tables but it is throttling my whole SharePoint site and just ending in a strange "Can't Process" error I have never recieved.  Maybe if I was loading less data this would work, I'll keep this idea in my back pocket.