1 of 1 people found this helpful
Your best bet would be to preprocess your data so you end up with a 'Movies' table and a related 'Genres' table with a many to many relationship between them. In other words, each move could have one or more related Genre rows. That would allow you to pull the Genre dimension in and you'd be all set.
If you don't want to or cannot go down that path, you have a couple of options;
1. Create a parameter which is a list of genres. Drag your existing combined 'Genre' field to the filter shelf, click the Condition tab, select 'By Formula' and enter CONTAINS([Genre],[paramaterGenre])
This will filter your genre string where a match is found with the genre parameter.
The limitation with this approach is that it's single select.
2. A similar question came up yesterday. There are some links contained within with some methods you might be able to utilize yourself - Filter values in multiple columns . Effectively the wildcard search might be the next best bet but the obvious downside being the user has to type the genres rather than select them.
While it's the most work, I think pre-processing is really the only true way to get what you're
Couple of interesting ideas there. I'm away for the next day or so (attending a Tableau 10 Roadshow in Dublin), so I'll have to wait before I have the opportunity to try them out ... I'll let you know how I get on!
I just wanted to say Thanks again Tom W ...
It took a bit of time to get back to this, but I finally put it all together & used your solution to break the Genre data out into a second table ... a bit laborious, but worth it ...