Filtering table

[gree1502]

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 

[Sean]

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!

[gree1502]

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]

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? 

[gree1502]

The requirement is different. Sorry for the confusion.

There are 5 bar graphs, with just one bar representing count. When I click one bar from the a particular bar graph, it should update the table independent of other bar graphs. 

The cross filter is only between table and one bar graph.

Is that possible?

Thanks

[parry2k]

I'm still lost. Can you help me understand if data source for all the tables/bar graphs on your report is same. Also can you put some screen shot to help it understand better. As much as I (everyone) like to help you but I'm having hard time understanding the requirement. Sorry , it must be me.

[gree1502]

Thank you for following up.

Sorry for the confusion again.

Below is the screenshot.

There are 3 bar graphs for eg:

All three representing count. Each of these bar graphs which increases/ decreases the count based on

a filter which I think is irrelevant here.

For now let us think the count is static on the bar graph.

If I click on the any one the bar graph, the table should filter and show only those particular ID's.

Eg: If I click on graph A, the count is 25. The table should only 25 values.

I have seen that edit interactions should work for this type of requirement, but it isn't working.

Any help appreciated!

Thanks

[gree1502]

Hi,

All the data is from the same table.

Thanks

[parry2k]

This is helpful. We are on the same page now.

Assuming, there is no filter at this point, what happens when you click "Count of A" bar? 

[gree1502]

When I click the bar of A, the table should filter and show corresponding 25 ID's.

But the table seems to have no effect when I click on the bar (I am using edit interactions currently).

I don't know where I am going wrong.

Thanks

[gree1502]

Thank you so much. Its working:)

Axis thing helped me!

But can you please brief me on the reason to drop the count on axis?

Thanks again

[parry2k · Accepted solution]

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....