my workbook connects to 8 different datasources, has 120 sheets and 10 dashboards....

I have a date field (has 10 quarters of data on primary datasource) that i also use on Columns and as a filter is assigned to 75 different sheets as a global filter and used in 8 dashboards as a filter drop-down....

when i select "Only Relevant Dates" it shows all values, 2061 Q1 thru 2018 Q2, a total of 10 values.  If i select "Only values in Database", it only shows 3 values...  can anyone explain??

does it take into account the values that ALL datasources have in common and only show the 3 common values among all datasources???

thanks