How to handle a scenario where we need to have relationship between three columns between two tables

[PB_dev]

We have two tables, where there is a single active relationship , say 'column_A1' from both the tables. In a paginated report, page 1 has data from table A, and page B has data from table 2. There is a drill-through configured from page 1 to page 2 using the same column_A1. I need the page 2 to be filtered based on column B2 & column B3 also along with column B1(=column A1).

Could anyone help me with this? Please let me know if the question is not clear. Thanks in advance !

[Tejasvi]

Hi All, 

I found a way to resolve the issue. Create a concatenated calculated column(with three columns) in both the tables A & B and have an active relation between this created column in both the tables. That way it helps us to solve the issue.

[v-xulin-mstf]

Hi @PB_dev,

It’s not supported now in power bi, you can vote here.

If you want to learn more, please refer: limitations-and-considerations

Best Regards,

Link

[Pragati11]

Hi @PB_dev ,

Just by reading your scenario, what you can try is keep your other 2 columns on the PAGE 2's following section: along with COLUMN 1:

Just remember to KEEP ALL FILTERS sections ON and move all 3 columns to "Add drill-through fields here" section.

Let me know if this is what you are looking for.

Thanks,

Pragati