It's a bit "hacky" but the best way I've found to "filter multiple columns at once" is to build a "Combined Field" of all the columns you want to "contribute" to the filter field, (I am old-school and always build a calculated field using concatenation.
[Field 1] + '-' + [Field 2] + '-' + STR([Field 3]).
As long as your fields aren't numeric, the + operator functions to perform a concatenation. IF you have numeric fields, wrap in a STR() function.
You can expose a multi-select that can be ugly, but you can also just employ that field as a wildcard quick filter.
The user can just type in "Yes" and see data for all records that have "Yes" present in any of the columns.
1 of 1 people found this helpful
Can you pivot those [Person X] columns into one column?
You could then have a simple filter where your user can select as many or as few Persons as he wants.
That's not the end of the solution though. Standard filters in Tableau do "OR" operations. If you want only those rows where ALL the selected people used the station, you could create an additional filter that only selects stations that all the selected Persons used. There are ways to do that, and it
can get a little complicated, but before going into all that, first find out if you can pivot your columns into one column (either using Tableau's PIVOT feature if the data source allows it, or do it in the creation of your data source if Tableau can't pivot your type of source.)
Just a question - your created a table by putting People in separate columns - did you consider creating a file with person / station and joined the 2 tables you would have a table with a dimension for Person and another for Station which could be filtered with quick filters
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
This worked! Thanks!