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 o...
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
     
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.