Table highlighting across pages?

[arichards]

I have a table (Table A) that when I highlight a row, it filters the other visuals on that page (specifically, another table - Table B).

I want to move Table B to another page (ideally setting up with a drill though), but the table highlighting filter doesn't seem to work across pages (and I can't get Drillthrough to show up either). Is there a setting I'm missing? Everything works fine when the tables are on the same page, but copying one of the dependent visuals to another page loses the filtering.

I'm not sure what other information I can include to help debug this issue.

[v-diye-msft]

Hi @arichards 

1. If you'd like to filter the rows across pages, did you try this option?

2. If Drillthrough preferred, please kindly share your dummy pbix, that will be easier for us to find the problem. also, please kindly refer to the official documentation for details:

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough 

[parry2k]

@arichards you need to set drillthrough on 2nd page. Hope this post helps.

[arichards]

@parry2k I've tried that - not sure if I'm doing something wrong?

But I end up with a screen for "Allow drillthrough when "Used as a category" with all the individual options (and no way to mass select?). It also has "summarized", but that doesn't seem to help either?

[parry2k]

@arichards can you share pbix file, remove any sensitive information before sharing.

[arichards]

I haven't had to share one before, any guidance on what to do for this? All of my data is internal company data, so I'm not sure how to go about this in a way that's useful for you.

[arichards]

Sharing my table setup might help

Project:

+ Project Id (PK)

+ Project Name

+ Project Group

Project Runs:

+ Project Run Id (PK)

+ Project Id (FK to Project table)

Task Runs:

+ Task Run Id (PK)

+ Project Run Id (FK to Project Runs)

+ Task Id (FK to Tasks)

Tasks:

+ Task Id

+ Task Name

+ Task Group

So, relationships:

+ Project to Project Runs: 1:*

+ Project Runs to Task Runs: 1:*

+ Task Runs to Tasks: *:1

+ Not explicitly stated, but project to tasks is 1:*

I have Projects in a hierarchy slicer and displaying Tasks in my grid (which includes some stats about Task Runs using DAX calculated measures), filtered by the hierarchy slicer. I want to display the related task runs when you select a task from the grid (which works on the same page, but not on a separate page). Using Task Id, Task Name, etc. all give me the "When used as a category" dropdown)