Filtering data in the current tab

You can filter the data that appears in all visualizations that use the selected data asset in the current tab of the dashboard or story.

If you add the same column to the All tabs filter and to the This tab filter, the members that you pick in the All tabs filter are applied to the This tab filter. For example, you add the Year column to both filters. You filter All tabs to show 2015, 2016, and 2017. The This tab filter will show only these years and you can filter the years further.

You cannot drag a column between the All tabs and This tab filter areas.

Procedure

  1. In the Sources pane, expand the data asset to see its contents.
    Data icon

    If you don't see the list of data assets, click the Switch to edit icon.

    Switch to edit icon
  2. Drag one or more columns to the This tab filter area. You can change the order of columns that have been added to the filter.
    Tip: Any selections made in the current tab are cleared when applying any filter in the This Tab filter area by selecting a subset of values.
  3. To define the filter, click the column in the This tab filter area.
    • If the column contains distinct values, select the member or members that you want to filter on.
    • If the column contains continuous values, use the slider to select a range of values to filter on. You can also click the start or end points of the range and enter a number.
    • If the column is a hierarchy, expand the levels in the hierarchy and select the members or levels that you want. For example, select 2017 and each quarter in 2016.
    • If the column has the data type of date, time, or timestamp (also known as datetime), select before, after, or between for the dates to include in the filter.
  4. Click OK.