05 Dec Tableau – Filter Dimensions
Filter Dimensions means Filtering by categorical values, like regions, or products. These are filters applied to the Dimensions field. Let us apply the Dimension filters on the subcategory of the products.
Let us create a new sheet in the same Amit_Tableau_Filters.twb Tableau Workbook.
Display profit for each sub-category of products according to their shipping mode. We will drag the:
- Dimension Ship Mode and Sub-Category to the Rows shelf
- Measure Profit to the Columns shelf
Here it is,
Drag the Dimension Sub-Category to the Filters. This opens the Filter dialog box section:
Click on the None button at the bottom of the list to deselect all:
After that, select the Exclude option in the bottom right to exclude all the categories:
Select the categories to exclude. We will exclude the following four categories, you can exclude any of them to filter:
- Appliances
- Chairs
- Copiers
- Furnishings
Click Apply and then OK:
The four excluding categories will not be visible now. This is how we apply filters on dimensions. We have renamed the sheet as Filter Dimensions:
If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.
For Videos, Join Our YouTube Channel: Join Now
Read More:
No Comments