Filter

[Cursos]

Hello I need to place in a report of several sheets a main filter, that when I move in the main panel it moves in all the graphs, example I select company and date and that all the 30 graphs of the different sheets only show that information of the selected one.

[Lobo-Google]

Hi @Cursos, thank you for your post!

Assuming you would like to create a report filter that report viewers can interact with:

You can certainly create a filter control for users to filter by, and set it up so that when a user filters the report, it is applied to all of the pages on the report. As outlined in the Make a control appear on every page section of the About controls documentation page, you can either create or edit an existing control, and then select the Make Report-level option from the Arrange menu underneath the report title. 

There may be some limitations, depending on whether all of the data in the charts is from the data source or not. The Use controls across data sources documentation page has more information regarding those limitations.

You can also let users filter the entire report by clicking on an area or data point on a chart, when chart cross-filtering is enabled for charts that support cross-filtering. This is subject to the same limitations, when charts use different data sources.

I hope that is useful information, and helps you achieve your desired outcome!