Help with Mutiple Filter options

[lipao255]

Hello, everyone.

I downloaded a NetFlix dataset wich contain a lot of movies and shows details. From description, imdb score, imdb votes, production countries, and so on.

I've almost finished the dashboard, however I cant find a solution for filter options.

As you can see "Genres" filter option has many values, like "Action", "Action, Animation", "Action, Sci-Fi", etc. I don't like this. I want to create a filter option with single values, like "Action", "Animation", "Sci-fi" etc. And when the user selects "Action" it will show all movies and shows that contains "Action", and also the ones like "Action, Animation". 

This problem also happens with "Country Productions" filter. How can I solve this issue?

Thank You.

[lipao255]

I also need help with how many movies or shows an specific country has produced. For example, Brazil ("BR") has 60 participations in movie productions.

However, its only counting 51 acurrences. What kind of dax formula can I use to solve this problem?

[indkitty · Accepted solution]

Hi Lipao255,

I had done something similar longtime back. From your dataset, you could create another table with "imdb_id" and split the production countries which are seperated by comma. 

Connect this table to your table (fact) with "imdb_id" as key. you could remove production countries in the fact table.

Below example.

From

Into

Split columns by delimiter - Power Query | Microsoft Docs

[lipao255]

Thank you, it solved my problem. Now it looks way better.

[indkitty]

Glad it worked out.

IMDB dataset contains comma seperated. This applies to actors, producers, writers etc.

[indkitty]

Hi lipao255,

Can you use text filter as visual filter?

Let me know if this resolves your issue.

[lipao255]

Is there a way to use it as suspended list? I don't think it's suitable for a user to type the genre.

[indkitty]

Do you mean as drop down list? if not, you could again use create another table with split column with comma from genre. It is similar to production countries as I mentioned earlier.