Filter up to three genera

[Syndicate_Admin]

Hello good evening.

I have a base where movies and TV series are listed. Each row has one, two or even 3 types of genres in different columns, classified as 1st genre, 2nd genre and 3rd genre. Assuming that a movie for example, is action, adventure and comedy.

I would like to be able to place in the dashboard that I am putting together a segmenter by category, but that the filters are cumulative, that is, that I can label a gender, and by marking a second gender it filters me both by the first gender and by the second. Example, I call action, then I call adventure, bring me the titles of action-adventure only.

I paste them under the DER so that they see how the tables are joined, the gender table would say according to the ID that the titles table has, if it is action, comedy, adventure, etc.

Thanks for the help.

[v-easonf-msft]

Hi, @Syndicate_Admin 

Not quite understand what you mean. Are you referring to a slicer with hierarchies?

Can you give a specific example to illustrate?

Best Regards,
Community Support Team _ Eason

[Syndicate_Admin]

Hello thank you for your reply. I wouldn't know how to tell you why I'm new to this world and what you mean by a "cutter with hierarchies". As I mentioned, I have a sample database, which contains movie titles. Each record contains one, two or even three genera. An example would be that Row one has in Column 1st Genre, a number 1 that related to the table of Genres, that number is an ID that in the row of the table of Genres, indicates that it is Action. Then in the main table, following the example, row 2 has another different title, with a number 1 in column 1st genre, and a number 4 in column 2nd genre (which by the relationship with the table of genres, the 4 would be drama, then the second title would be of genre Action - drama). I would like to be able to put on the control board, a segmenter with a drop-down list of genres, which, as the user ticks each particular genre, will bring you the titles that meet this condition. But, currently I am analyzing only the first column of genres, how can I make the system analyze up to the 3 possible types of genres that EACH title can have? So, if the user in the segmenter ticks three genres, filter out the titles that meet only those 3 conditions together, not separately (i.e. if they choose action - adventure - comedy, bring only the titles that have action in the 1st genre column, adventure in the 2nd genre column, and comedy in the 3rd genre column). Let me explain?