Filtering a dashboard across multiple datasets
I am trying to use a page filter to filter my dashboard which consists of multiple cards and about 5 different data sets. All the datasets have the column that I want to filter, but yet when I try to apply the filter it doesn't apply to all options.
Say the filter is 'name' and I want to filter everything with the word apple in the name. So I type in apple and click apply to all. However, if i they type Apple Fruit it shows a whole bunch of titles which haven't been selected even though they should have been by filtering just on apple.
Why is this?
the only thing I can think is that there is a limit to the number of options that can be filtered? Admittedly it is a large dataset.
Thanks for your help