Mastering Filters in Tableau: Blue and Green Pills Explained

Learn how to effectively utilize blue and green pill filters in Tableau to create dynamic and interactive data visualizations. This video guides you through the process of creating subcategory-level sales charts and demonstrates the application of categorical (blue pill) and numerical (green pill) filters.

What will you learn

• How to differentiate between blue and green pills in Tableau.
• The function of blue pills as dimensions and green pills as measures.
• Step-by-step guide to creating subcategory-level sales charts.
• How to apply and customize blue pill (categorical) filters.
• How to apply and customize green pill (numerical) filters.
• Practical examples of using range filters and slider bars in Tableau.

Takeaway notes

• Blue pills represent dimensions, which are categorical fields.
• Green pills represent measures, which are numerical fields.
• To add a filter, you drag the desired field to the filter section.
• Blue pill filters display categorical selection options.
• Green pill filters enable numerical range selection using sliders.
• Filters can be displayed to users for interactive visualization adjustments.
• Blue pill filters are useful for segmenting data by categories like region.
• Green pill filters allow for filtering data based on numerical values like quantity.

Practice questions

1. What do blue pills represent in Tableau, and where are they used?
2. What do green pills represent, and how do they differ from blue pills?
3. Describe the steps to create a subcategory-level sales chart in Tableau.
4. How can you add a categorical filter (blue pill) in Tableau?
5. What kind of dialog box appears when you add a blue pill filter, and what options does it provide?
6. Explain how to display a filter to the user in Tableau.
7. How can you filter data by region using a blue pill filter?
8. Describe the method to apply a numerical filter (green pill) using quantity as an example.
9. What are the different filter options available for numerical fields in Tableau?
10. How do you use the slider bar to set a range for a green pill filter?
11. What is the significance of displaying both blue and green pill filters to users?
12. Give an example of when you would use a 'range of values' filter in a Tableau visualization.
13. How can you adjust the lower and upper limits of a numerical filter slider in Tableau?
14. Can you type specific values directly into a green filter dialog box? Give an example.
15. Discuss how dimensions and measures can be combined to create complex filters in Tableau.