Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Use table filters between 2 tabs

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

 

 

 

General Comment
Need Help
Tips and Tricks

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.