Help on Visual

[Anonymous]

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

[v-jingzhang]

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.

[selimovd · Accepted solution]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic