Forum Discussion

gree1502's avatar
gree1502
Helper II
9 years ago
Solved

Filtering table

Hi,

 

I have a column called "ID" with unique values. A bar chart using this column shows count of ID.

 

Also I have a table representing all the values of the ID.

I am applying a visual filter on bar chart. What I need is that, the table also filters based on bar chart.

 

I have used edit interactions after reading articles which says it is possible. When I use page level filter it works.

But I don't want to use page level as it affects other bar graphs. Can I do it using visual filter?

 

Thanks 

  • parry2k's avatar
    parry2k
    9 years ago

    Seems like because you don't have any field on Axis, you cannot cross filter. Do one thing,

     

    drop A field on Axis on Count of A Graph

    drop B field on Axis  on Count of B Graph

    drop C field on Axis on Count of C Graph

     

    and then try....

11 Replies

  • Sean's avatar
    Sean
    Community Champion

    If you don't want to use the Page Level Filter you have to add the same Visual Level Filter to each Visual you want affected!

    OR

    Use a Slicer and Edit the Interactions to limit the Slicer to only affect the Visuals you choose! :smileyhappy:

    • gree1502's avatar
      gree1502
      Helper II

      Thanks for the response.

       

      I cannot go with second option because, I have 5 bar graphs and if I click on each bar graph, the table should be updated.

       

      I did the 1st option, but it isn't working. 

       

      What could be the possible problems?

       

      Thanks

      • parry2k's avatar
        parry2k
        Super User

        When you say it is not working, wat does that mean?

         

        Here is what I understood, you have 5 bar graphs and a table from same dataset, logically when you select any of the bar from a graph, it will cross filter other graphs and table assuming interaction is enabled between visuals. Is this working as expected?