multiple relationship for two tables for filtering purpose

[Anonymous]

Dear all,

I'm new to the power Bi and I have one concern regarding to set the filter for two tables by using the relationship function.

For example:

Table 1: there is 3 column

Year

Place

Expenses

Table 2: there is 4 column

Year

Place

Week

People working

I created an active relationship between Year of Table 1 and Year of Table 2 and an unactive relationship for Place of 2 tables.

Then I draw a line chart for each table.

My question is: I can only filter the year for both tables by using the Report Level fiter since it is an active relationship.

Is there any solution so that I can also filter the Place for both tables?

Much appreciated for your supports.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create a table 3 with one column:Place. Then link  table 3 with table 1 and table 2.Use table 3 place column as slicer to filter the two tables.

Regards,