How to combine two slicer into one to optimize filtering

[Anonymous]

How do I combine two filtering fields into one to filter the dashboard on the combined filter rather than having two filtering slicers individually.  For instance, I have two fields that look like below:

Now I want to combine these two fields (sort of in the form of union logic). 

Can I achieve this here?

[Anonymous]

Thank you so much @amitchandak . That was helpful. It works 🙂

[amitchandak · Accepted solution]

@Anonymous , if they are from two tables you need to create a common table using those. and Join back. even from same table , You can put them same table(Distinct Union All/Distinct) and join both columns with a new table. One join will be inactive( That you can activate in a measure using userelationship)

Common table https://www.youtube.com/watch?v=Bkf35Roman8

Use relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

[Anonymous]

@amitchandak this is working fine for one of the tables that I have an active relatinship, but I am wondering how I can activate the relationship between two of the tables and the union table because I am unioning three tables and two of them have inactive relationship. Now even if I am able to union the tables, the filtering table is not being applied on those that dont have active relationship with the unioned table. How can I solve this please?