4 Replies Latest reply on Sep 23, 2018 3:46 AM by September Clementin

    creating a filter for multiple graphs

    henry watson

      How can I create a filter where if i can make a selection, all the graphs on the dashboard can change according to that selection at the same time?  For example if there are two graphs, with the first one (line graph) showing amount of points scored by 2 basketball players (Michael Jordan and Lebron James) in one season. And the second graph showing what countries these points were scored in, in a world map.   When one player is picked from the filter (eg Michael Jordan)- the data on the two graphs refers to that player. And similarly if another player is selected (eg Lebron James) the graphs show the results of just that player. I hope this example describes what I am trying to do!

       

      If anyone can help I would be very grateful! Thanks!

        • 1. Re: creating a filter for multiple graphs
          September Clementin

          Hi Henry.

           

          Click the Filter icon for that dashboard item (the 3rd icon that looks like a funnel in the image below).  It will filter any other object on the dashboard.

           

          --September

           

          If this post helps to resolve the challenge please mark it 'This helped me' and 'Correct Answer'. This will help other users find the same answer/resolution.  Happy dashboarding!

           

          FIlter Funnel Icon.JPG

          • 2. Re: creating a filter for multiple graphs
            Soham Wadekar

            Hi Henry,

             

            You can do this using the apply worksheets option in the filter

            - Click the small arrow on the quick filter and click Selected worksheets

            You will get something like this

            select the sheets you want to apply filter to and that will do it!

             

            Soham

            • 4. Re: creating a filter for multiple graphs
              suman kumar

              Hi Henry,

               

              This filter is called Universal Filter. Please see below link for Universal Filter in details and let me know if you have more question on this.

               

              Apply Filters to Multiple Worksheets

              Apply Filters to Multiple Worksheets

              When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.

              You can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources. For example, you might have a filter that only includes a specific region or product of interest. Rather than adding this filter every time you create a new worksheet, you can simply create the filter once and then apply it to multiple worksheets.

              Apply filters to all worksheets that use a related primary data source

              This option applies the filter to all worksheets that use related data sources as their primary data source.

              Note: To apply a filter to worksheets that use a related primary data source in web authoring, relationships between the data sources must be set up in Tableau Desktop, and then published to the web.

               

              For more information, see Filter Data Across Multiple Data Sources.

              To apply a filter to all worksheets using a related primary data source:

              • On the Filters shelf, right-click the field and select Apply to Worksheets > All Using Related Data Sources.

              Filters that use this option are global across the workbook.Filters that apply to all related data sources are marked with an icon. The filter is automatically created on any existing worksheets, and on any new worksheets you create that use a related data source.Any changes you make to the filter affects all of those worksheets.

              Apply filters to all worksheets that use the current primary data source

              This option applies the filter to all worksheets that use the current worksheet's primary data source as their primary data source.To apply a filter to all worksheets using the current primary data source:

              • On the Filters shelf, right-click the field and select Apply to Worksheets > All Using This Data Source.

              Filters that use this option are global across the workbook.Filters that apply to all worksheets are marked with a data source icon . The filter is automatically created on any new worksheets you create after you drag a field to the view.Any changes you make to the filter affects all of those worksheets.Note: If blending multiple data sources in a view, the All Using This Data Source option applies to the filter if it is the primary data source.

              Apply filters to select worksheets (Tableau Desktop only)

              This option opens a dialog box where you can select from a list of worksheets that use the same data source or related data sources.To apply a filter to select worksheets:

              • On the Filters shelf, right-click the field and select Apply to Worksheets > Selected Worksheets.
              • In the Apply Filter to Worksheets dialog box, select the worksheets that you want to apply the filter. If any of the sheets already contain a filter on the same field, the dialog box will provide details about the filter.If you select the sheet, the current filter will override any existing filter selections.

              Filters that apply to a selection of worksheets are marked with the worksheet icon . Any changes you make to the filter affect all of the selected worksheets.

              Apply filters to the current worksheet only

              This option only applies to the current worksheet. This option is selected by default when you create new filters. Filters that are local to the current worksheet are shown without any additional icons.To apply a filter to the current worksheet only:

              • On the Filters shelf, right-click the field and select Apply to Worksheets > Only This Worksheet.

              If you apply a filter to all worksheets or selected worksheets and then change the setting to apply the filter to just the current worksheet, the filters are not removed from all other worksheets. Rather, the filters are disconnected and they are all made local to their respective worksheets. You can go to each worksheet and remove the filter or modify selections.

              Filter all worksheets on a dashboard (Tableau Desktop only)

              This option applies the filter to all worksheets in the dashboard that use the same data source or related data sources as their primary data source.To filter all worksheets on a dashboard:

              • In a dashboard, click the drop-down menu on a filter card and select Apply to Worksheets>Selected worksheets.
              • In the Apply Filter to Worksheets dialog box, click All on dashboard, and then click OK.

               

               

              Please mark correct and helpful if it works for you

               

               

              Best

              Suman