Use table filters between 2 tabs

[Anonymous]

Hi,

I am having table A in first tab and Table B in 2nd tab.

FIRST TAB OF A REPORT

Column1   Column2

A                10

B                20

C                30

SECOND TAB OF A REPORT

Column1   Column2

A                80

A                90

B                70

B                60

I wanted something like if i select A of TAB1 then it should automatically go to second tab report and display 1st 2 rows of second table  because i have selected A from the 1st tab.

Thanks,

Shubham

[v-juanli-msft]

Hi @Anonymous 

It should be possible with "drillthrough" feature.

Is the "column2" in table 1 the same as "column2" in table2?

Why do they show different values?

Is there any filter on this column on two tabs?

In my test, add "column1" in the drillthrough" filter field on "Tab(page)2",

then drillthough from table1 in "Tab1" by selecting the row and right-click on that row.

You could download my pbix and drill through from my "page1".

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.