Forum Discussion
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
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
- SeanCommunity 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:
- gree1502Helper 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
- parry2kSuper 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?