Forum Discussion

hgromek's avatar
hgromek
Frequent Visitor
4 years ago

Test Search box - multiple tables and visuals

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 TEX...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
hgromek
Frequent Visitor
4 years ago

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.