Tableau only relevant values vs all values in context. In this case, we have two hierarchical filters, it would be best if we keep the upper level filter (Country) as from ‘All Values in Database’. That is, each filter accesses all rows in your data source without regard to other filters. Jun 3, 2015 · Tableau is forced to run not just one query to pull all values for each quick filter, but it has to run a second sub-query in order to populate the view on each selection based on relevancy with other filters on the dashboard. If you’re searching for a student whose name contains ‘Jo’, rather than try to filter the entire student field by searching for ‘Jo’, first filter to the relevant grade level, then have the student name field return only relevant values. Nov 10, 2025 · You make one selection, it trims the values in all the other filters, but when you want to change it, you find yourself trying to dig yourself out of the relevant values maze you've created for yourself. However, you can set one or more categorical filters as context filters for the view. . The above image shows where to select 'Only Relevant Values' in the filter option menu Now when 'Only Relevant Values' have been applied to the filter a shorter list of values in the category filter is shown, compared to the first image, when 2019 has been selected in the Year filter. By default, all filters that you set in Tableau are computed independently. This blog shall outline how to only show the values that in one filter that correspond to a value selected in another filter. fvng pxbbp qsp nctcq cldmp olovenr rzfd dcwdq uha zxvkb