Apply same filter across multiple sheets

Q&A
, ,
3

parameters work great for us, and we use them a lot. In fact I only learned about filters without a parameter only recently.

Anyhow, working with parameters is a three step process.

  1. Create a parameter for the analysis
  2. for each sheet in the analysis, create a control that is based on that parameter.
  3. as necessary, for each visual on each sheet, create a filter that references the parameter (or use the functionality on the filter that says to apply this filter to all visuals using this dataset on this sheet).

Once you get the hang of creating parameters, controls, and filters, one can get crazy with this. We have dashboards with a dozen parameters, so name your parameters and controls well so that someone a year later can figure out what the intent was.

Also the values that the user selects from a control based on a parameter, can be embedded in titles and subtitles of visuals, ie you can embed a parameter into a title or subtitle.

1 Like