Learn which types of Tableau filters appear in the Edit Data Source Filters dialog, including dimension filters across all sheets vs sheet-specific filters. Ace your Tableau certification exam with this expert explanation.
Table of Contents
Question
You have a Tableau workbook that contains three worksheets named Sheet1, Sheet2, and Sheet3.
You create several filters.
From the Data Source page, you plan to add data source filters.
Which type of filter will appear in the Edit Data Source Filters dialog box?
A. A context filter on a dimension in Sheet3
B. A table calculation filter used on Sheet2
C. A top N condition filter on a dimension in Sheet1 and Sheet2
D. A dimension filter on all the sheets
Answer
D. A dimension filter on all the sheets
Explanation
The correct answer is D. A dimension filter that is applied to all the worksheets in the workbook will appear in the Edit Data Source Filters dialog box.
Data source filters are applied before any other filters, directly in the data source. They filter the data before it is used by any worksheets.
The other filter types mentioned would not show up in the Data Source Filters dialog:
A) A context filter on a specific worksheet (like Sheet3) is not a data source filter. It would be configured in that individual worksheet.
B) Table calculation filters are computed after the data is aggregated in a specific worksheet. They are not data source filters that get applied up front to the raw data.
C) A top N condition filter on specific worksheets (like Sheet1 and Sheet2) would be configured in those individual sheets rather than as a global data source filter.
Only dimensions that are filtered across all sheets in the workbook will appear as configurable filters in the Edit Data Source Filters dialog. The other types are worksheet-specific filters rather than global data source filters.
In summary, dimension filters that are applied globally to all worksheets are the type that will show up in the Edit Data Source Filters dialog box in Tableau. The other filter types mentioned, like context filters, top N filters, and table calculation filters, are applied at the individual worksheet level instead.
Tableau TDA-C01 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Tableau TDA-C01 exam and earn Tableau TDA-C01 certification.