How can I link two different slicers to two different table in Power Bi?

[Anonymous]

For example I can link one slicer to two different tables by creating a relationship between two tables but what if I need to filter it with another column but it won't let me.

[GilbertQ]

Hi @Anonymous 

If you need to do this with multiple columns you will need to create a composite column, which means combining the values of the 2 columns together into one column. And then use this column to create the relationship with that new composite (think combined) column.

[Anonymous]

Hi @GilbertQ,

Thank you for the response, I am fairly new here so if I am asking the wrong question I apologize. Please let me explain, for example what I am doing is I have two tables with multiple column and table 1 has for example column name fruits and in there I have 10 rows of different fruits and fruit types also with 10 rows and different fruit types. So, on my table2 I also have multiple column with different fruits and here I have 100 rows of data and Fruit types also with 100 rows of data. For example I can right now create a relationship between Fruits column and put a slicer and that slicer filters out both the table data but if I put another slicer in for the Fruit type, it won't filter the data for both the table because I have fruit as the active relationship. So, how would I also be able to use the fruit slicer as well as fruit type slicer to filter both the table data.

Please help.

[GilbertQ · Accepted solution]

Hi @Anonymous 

What you would need to do is to create what is called a dimension table which has got all the fruit and fruit types.

From this new table you then connect it to both of your tables (10 rows and 100 rows), and then you use the slicer from this new table.

Here are more details: Create a dimension table from other tables - How? - Microsoft Power BI Community

And star schema with dimensional modelling is something I would strongly suggest you spend some time learning!