How to Hide Data with a Filter in Tableau (LOOKUP, LAST, FIRST)

🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8

Did you know you can hide data with filters in Tableau? It's a handy trick for referencing data you don't want displayed visibly. For example, if you want to calculate year over year growth but only display the latest year, you can't filter the prior year out of your worksheet or Tableau will not be able to reference the prior year values.

Hiding data with a filter in Tableau is an expert trick you should know about. One of the best ways to 'hide' data with a filter is to use a Table Calculation filter. Table Calculations filters are one of the last steps processed in Tableau's order of operations. They are even processed after your standard table calculations (e.g. Percent of Total, Rank, Percent Difference) are computed.

LOOKUP, FIRST and LAST are powerful table calculation functions you can use to 'hide' your data with a filter. Check out this video to learn how!

Connect with us:
•Upcoming Tableau Classes: https://onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  

Resources:
•Example Tableau Workbook: https://public.tableau.com/app/profil...
•Month Over Month Summary Tiles (LAST Filter): https://onenumber.biz/blog-1/2021/9/5...
•Slope Chart Walkthrough: https://onenumber.biz/blog-1/2022/1/4...

Chapters:
0:00 Background & Order of Operations
2:08 Manually Hide Values
2:37 LOOKUP Function Filter
6:55 LAST Function Filter
9:35 Keep Last 2 Columns
11:18 FIRST Function Filter
11:39 Upcoming Classes