Once you have added a filter for a visualization in a dashboard, you can select formatting options for the filter. For example, you can determine whether to show the filter's title bar, or determine whether to display the filter as check boxes or a slider. This type of filter filters the data within a specific visualization, to select what data is displayed on the visualization. You can also use this type of filter to filter the objects displayed in a filter that targets a visualization. For examples and more detailed descriptions, including steps to create the filters, see Creating a filter for the data on a visualization.
To format a filter for a sheet:
Click the name of the dashboard to run it.
Click the tab of the sheet that contains the filter.
Click the filter to format.
If the Properties panel is not
displayed, from the View menu,
select Properties Panel. If
the Properties panel is hidden behind another panel, click the Properties icon 
to display the Properties panel.
The following options are available to format the display of items in the filter:
The options available vary based on the type of filter that you are formatting.
Style: Select the style to use to display the filter, such as Slider or Check Boxes.
Text: Select the font to apply to the text in the filter. You can also:
Determine whether to apply Bold, Italic, Underline, or Strikethrough formatting to the text.
Select the font size for the text.
Select the font color for the text.
Select the orientation of the text. Your options are Automatic, Horizontal, and Vertical.
Mode: Determine whether to include or exclude data for the items selected in the filter. For example, a filter contains a list of regions, and Central and South are selected. You can choose to display data only for the Central and South regions, or display data for all regions except Central and South. The options are:
Include (default): Display data for the items chosen in the filter.
Exclude: Display all data except the data for items chosen in the filter.
Allow multiple selections: Determines whether you can select multiple items in the filter, allowing the target visualization to display data for several items at once. To allow only a single selection, clear this check box.
Make all items the same width: Determine whether to display each item in the filter using the same width, or proportionally, which means that the width of each item is proportional to the length of the text inside the item. (Cleared by default.)
Show option for all: Determine whether the filter shows the All option, which displays all the attribute values, custom group values, consolidation values, or metrics in the target. (Cleared by default.)
Alias: Replace the All option in the filter with the entered text. If no text is entered, (All) is displayed. (Available if Show option for All is selected.)
Show option for total: Determine whether the filter shows the Total option, which displays the total for all attributes, custom groups, consolidation values, or metrics in the target. (Cleared by default.)
The following options are available to format the title bar of a filter, which contains the filter's name, and the container in which a filter is displayed in the dashboard:
Title
Show Title Bar: Determine whether to display the title bar.
Text: From the drop-down list, select the font type, then determine whether to apply Bold, Italic, Underline, or Strikethrough formatting. Select the font size and font color.
Fill color: Select the background color of the title bar text.
Alignment: Select the horizontal alignment of the title bar text. Your options are Left, Center, or Right
Container
Fill color: Select the background color of the filter
Outer border: Select the line style and color of the border to display around the filter.
Creating a filter for the data on a visualization
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices