Forum Discussion

arichards's avatar
arichards
Frequent Visitor
6 years ago

Table highlighting across pages?

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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

arichards's avatar
arichards
Frequent Visitor
6 years ago

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's avatar
    arichards
    Frequent Visitor
    6 years ago

    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)