Table highlighting across pages?

Question

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.

parry2k · Answer

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

arichards · Answer

parry2k&nbsp;I've tried that - not sure if I'm doing something wrong?&nbsp;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 · Answer

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

arichards · Answer

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 · Answer

Sharing my table setup might helpProject:+ Project Id (PK)+ Project Name+ Project Group&nbsp;Project Runs:+ Project Run Id (PK)+ Project Id (FK to Project table)&nbsp;Task Runs:+ Task Run Id (PK)+ Project Run Id (FK to Project Runs)+ Task Id (FK to Tasks)&nbsp;Tasks:+ Task Id+ Task Name+ Task Group&nbsp;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:*&nbsp;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)

Forum Discussion

Table highlighting across pages?

6 Replies

Related content

Tooltip page

Mobile Pages height

How to add Page 1 , Page 2 & Page 3 into single page table report.

Blank Page - Embedded Report

Table Highlight in Desktop