Forum Discussion
Filter by more than one control
I'd like to be able to filter by a combination of controls at once. Is this possible?
For example, here's a page I'm working on:
I'd like to be able to click on a column in the team plot and a column in the year plot so that the data in the remaining plot is filtered by both. Currently when I click the second plot, the first filter is removed. Is this possible and if so how? I know that sliders kind-of give me that functionality but I'd like it directly from the plots.
3 Replies
Mist I have been waiting for that long. Not possible at this stage by just clilcking on the visual.
However what you can do is drop fields from your team and year plots onto 'Report level filters' under 'Filters' section on 'Visualizations' pane. Doing this you will have forward and backward dependency. So when you select a value from first filter second filter will be updated and vice-versa and your plot / visual will display accordingly.
Thanks for the quick reply ankitpatira. I'm not quite sure I understand but I will have a play with it and see.
I could not get this to work ankitpatira. Here's a snapshot of how I setup a (different) page with the Report level filters as suggested. Any idea what I've done wrong?
