Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

multiple relationship for two tables for filtering purpose

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.

 

 

  • 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,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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,