Forum Discussion
ghutchins
6 years agoHelper II
Relevant Data in Filters
I would like to limit the options in filters as values are selected in other filters. This was easy in Tableau, I just click "Only Relevant Values" in the filter settings. Is there a way to do this...
Pragati11
6 years agoSuper User
Hi ghutchins ,
I tried the similar scenario at my end and it seems to work. Consider following example:
Now if I select anything in my 1st filter, 2nd filter reflects the chnage:
Both of my above filters are coming from same table.
At your end, are they in same table?
If they are not in same table, then are they coming from related tables?
Thanks,
Pragati
ghutchins
6 years agoHelper II
I have a very busy Star schema that relates all tables to a Details (Fact Table) table, so I guess they are all related.
The options in each filter are coming from a seperate dimension table. I verified the relationships are set up correct.
I think everything is set up to the best known method but I must be missing something.
- AllisonKennedy6 years agoCommunity Championghutchins
Are you able to provide screenshots or replicate the problem with sample data in a sample file that you can share here via onedrive?