Table Filter based on value from another table in different page

[srlabhe123]

Hi Team,

I have a scenario where table1 has columns like Dept, In STock Rev, Out Stock Rev

Profit Department	In Stock	Out Stock	% OoS
Grocery - Dairy	1	0	0.00%
Grocery - Floral	1	0	0.00%
Meal Kits	25	8	24.20%
Floral	58	9	13.40%

Now hen I click on Grocery -Dairy (any value from column Profit Department)I want another Table 2 should be filtered for Grocery-Dairy values only.Please note the table 2 is on another page in same report.

Kndly suggest 

[parry2k]

There are few options:

- use drilldown functionality

- or use report level filters.

Currently selecting a row in a table on one page will not filter data on another page

[srlabhe123]

can you please elaborate more how to use drill down to achive what I want?

[parry2k]

on your 2nd page, in drillthroug Filters , add field "Profit Department"

on you page1, right click on "Proift Department" and it will show "Drillthrough" option in menu with your 2nd page listed in it, click that and you 2nd page will be filtered based on "Profit Department" you are drilling thru.

[srlabhe123]

Step 1 done but when I right click on profit dept in page 1 it doesn't show me any option of drill through to page 2...

[parry2k]

not sure why, just make sure it is same column in drillthrough.

[srlabhe123]

Step 1 :- Added Profit Dept as drill through filter in page 2 as below

Added as Drill ThroughNo Page 2 as in list after right click

[parry2k]

you have to right click on the profit department in a visual not in columns under table, sorry i was not clear.

[srlabhe123]

Its doesnt give me any menu if I right click on visual as well.... 

[parry2k]

let's say you have table visual and "Profit Department" column in it, click on that column and you will see a menu and I expect drillthough option in there

[srlabhe123]

Yes but user have to click on value and manually select the value as drill through Page 2...

What I want is to just click on any value in Profit Dept and then it should filter table in second page....

User Dont have to drill through and goto page 2....

[parry2k]

As at start of this thread I mentioned there is no option as of yet, either drill thru or report level filter (2nd option), it will all pages with whatever value selected in report filter. You can try that.

[srlabhe123]

Appreciate your effort ....

But How to setup selected value of table as report filter .... it seems that too is also not possible directly 

[parry2k]

user have to pick value in report level filter, no way to use selected value. 😞

[srlabhe123]

Agree ... as my requirement is to have dynamic filter based on the selected value in table...

[v-shex-msft]

HI @srlabhe123,

Current only drill through filter and report level filter can across report page, but they need to manually apply these filters.

For your requirement, I think you can vote below idea: 

Allows Slicers to apply to all Pages of a Report

Regards,

Xiaoxin Sheng

[srlabhe123]

I got it .... but its not filtering table in page 2....

[parry2k]

Perfect, we are step closer, not sure why it is not filtering. 

So you did see drillthrough option when right clicked on the column, correct?