Excluding data on the fly
We can easily set multiple filters on a visualization; however, while exploring the data, the user has a very common need to exclude certain data without explicitly creating a filter beforehand. Tableau offers this feature, and exclusion happens on the selected marks and a filter is created.
Getting ready
Let's use the sample file Sample – Superstore Sales (Excel)
. Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.
How to do it...
Once the data is loaded on the worksheet, perform the following steps to create a visualization and exclude or filter some data from the visualization:
- Click on the Show Me button to bring the Show Me toolbar on the screen.
- While holding the Ctrl key, click on
Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.