Dashboard filters provide filter controls for end users on an individual canvas.

As an author, you usually add and set filters in the filter bar to broadly limit the data in your workbook, see Use the Workbook Filter Bar. You can then add and configure dashboard filters on each canvas to allow end users to select their own filter values to change the data in the visualizations.

Dashboard filters are contained in the Dashboard Filters visualization. After you add the Dashboard Filters visualization to the canvas, you can then drag and drop columns to this visualization to create dashboard filters. Oracle Analytics assigns default properties based on the column you chose to create the filter but you can modify the filter's properties to better suit the data and improve the user experience.

Use the Dashboard Filters visualization to create and configure your dashboard filters.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Visualizations Panel, click Visualizations, scroll to Dashboard Controls, and drag Dashboard Filters to the canvas.
3. In the Data Panel, click Data and drag one or more columns to the new dashboard filters visualization to create the dashboard filter controls.
   
   
   Description of the illustration filters_dashboard_filter_example_on_canvas.png
   
   
4. Optional: Click a filter control to open the Filter dialog, then select the data values filter on.
5. Click Save.

You can specify how a dashboard filter gets its selection values, for example from the workbook filter bar or other dashboard filters.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click the dashboard filters visualization to select it.
3. Click Properties to open the Properties panel, then click Filter Controls.
4. Locate and expand the filter you want to set the limit by for.
5. Click the Limit Values By field and select how you want to limit the filter's selection values.
   
   
   Description of the illustration filters_canvas_limit_by_setting.png
   
   
6. Click Save.

When you add a dashboard filter, Oracle Analytics applies it to all visualizations on the canvas. You can specify which of the visualizations you want to apply the dashboard filter to.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click the dashboard filters visualization to select it.
3. Click Properties to open the Properties panel, then click Filters.
4. In the Apply This Filter To section, select the visualizations that you want the filter to apply to.
   
   
   Description of the illustration filters_apply_dashboard_filter.png
   
   
5. Click Save.

When you add a dashboard filter visualization, Oracle Analytics applies all of the workbook's existing dashboard filters and any filters in the filter bar to it. You can specify which of the filters you want to apply to the new dashboard filter.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click the dashboard filters visualization to select it.
3. Click Properties to open the Properties panel, then click Filters.
4. In the Filter This Viz By section, select the filters you want to apply to the dashboard filter.
   
   
   Description of the illustration filters_filter_this_viz_by.png
   
   
5. Click Save.

Where you add a dashboard filters visualization to the canvas determines if the filter controls are displayed horizontally or vertically.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click the dashboard filters visualization to select it.
3. Click Properties to open the Properties pane, then click General.
4. Click the Orientation field and select an orientation.
5. Click Save.

You can choose how you want the filter controls in the dashboard filters visualization to display to provide a canvas layout and filter experience that works best for your users.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click the dashboard filters visualization to select it.
3. Click Properties to open the Properties pane, then click General.
4. Click the Filter Style field and select a style.
5. Click Save.

You can use a parameter as a dashboard filter control to select and change the dimension and measure column values for the visualizations on a canvas.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Data panel, click Visualizations, scroll to the Dashboard Controls section, and drag Dashboard Filters to the canvas.
3. In the Data panel, click Parameters, and drag and drop a parameter to Filter Controls in the Dashboard Filter visualization's grammar panel.
   
   
   
   
4. Click Save.

You can add a slider dashboard filter to a workbook canvas and animate visualizations to show how the data changes relative to a specified dimension. Consumers can select a dimension value interactively, or automatically play through dimension values, similar to a time-lapse video or animation.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. In the Data panel, click Visualizations, scroll to the Dashboard Controls section, and drag Dashboard Filters to the canvas.
   
   
   Description of the illustration slider-select.png
   
   
3. In the Data panel, click Data, and drag a dimension-based data element to the new dashboard filters visualization.
4. Click Properties to open the Properties pane, then click Filter Controls.
5. Locate and expand the filter you just added.
6. Click the Filter Type field and select Slider.
   
   
   Description of the illustration slider-controls.png
   
   
7. Click the Play field to turn auto-play on or off.
8. If you enabled play, in the slider filter control, click Play to see how your visualizations play with the default settings.