Interaction between 2 visuals

[vlad_drigin]

I have a report page that has 2 tables:

Table 1:

Table 2:

I have applied some filters on the 2nd visual (table 2), however, I cannot apply the same filters to table 1.

I want table 1 to only display companies that are in table 2.

Is there a way of doing this?

Thanks a lot!!

 

[Anonymous]

Hi @vlad_drigin 

I have a question that why you cannot apply the same filters to table 1 ? As you said , the two visuals are from the same table with same fields. If you filter table 2 ,the data in table 1 will also be filtered .Unless you turn off the interaction between two visuals and forgot to turn it on .

You can check the interactions in Format => Edit Interactions .

Best Regards

Community Support Team _ Ailsa Tao

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

[lbendlin]

That's what a data model is for. Have you connected these tables?

[vlad_drigin]

Both of these tables (visuals) are made out of the same tables in data model, which are connected. In my question I mean table as a visual. When I apply a filter to one visual, I want all of the companies that are not in visual 2 to disappear from visual 1.

[lbendlin]

If the visuals feed off the same tables then that filtering would happen automatically unless you explicitly disabled interactions between visuals. Do you remember if you did that maybe?