Forum Discussion
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
Microsoft 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,