Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help on Visual

Dear Experts,

 

I need your  advice for below scenario:

 

I have two fact tables:

Table A contains the summary of table B and it contains the submission status.

Table B contains the   details of Table A , with company code.

 

I need to make visuals where I can  show Table A and when I click the table A line it will show  the table B details. See below illustration:

 

 

 

 

Visual- Where if I click the table in left will show the table in right Company details.

 

 

 

Thanks,

Leo

Need Help
Show and Tell
Tips and Tricks
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    connect the two tables by unique key 1:n.

    Then create a table with the values from Table A and a table with the values from Table B.

     

    When you click on a row in Table A, then Table B will be filtered.

    Next time please provide the data in a table not as a screenshot, that makes it easier to help you.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    connect the two tables by unique key 1:n.

    Then create a table with the values from Table A and a table with the values from Table B.

     

    When you click on a row in Table A, then Table B will be filtered.

    Next time please provide the data in a table not as a screenshot, that makes it easier to help you.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

     

    You could create a relationship between two tables on Unique Key column. Then when you click on a row in Tablel A visual, it will filter the Table B visual with the same Unique key.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.