How to show two different table values in Single Table visual

[deepuaits]

Hi Community,

I have 2 Tables like Your ResponseTable Values ((Your Response table RLS applied)  ) and Cohort Table Values (Cohort table RLS not applied)  but i have show the side by in single table visual.

Note: Visual leval filters are same for both the table ( Like ID 2 values and hedder string )

Thanks,

Pradeep

[wardy912 · Accepted solution]

Hi @deepuaits 

 You could merge the 2 tables as a new table on the column 'category name' and display the results of that table.

[v-priyankata · Accepted solution]

Hi @deepuaits 

Thank you for reaching out to the Microsoft Fabric Forum Community. 
@MFelix @wardy912 Thanks for the inputs.

As suggested by @MFelix, I have reproduced the scenario. Please take a look at the attached PBIX file. hope your expecting the same thing if not or If the issue still persists, feel free to reach out for further assistance.

Thanks.

[v-priyankata]

Hi @deepuaits 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @deepuaits 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @deepuaits 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. if you have any other issues please reach community.

[wardy912 · Accepted solution]

Hi @deepuaits 

 You could merge the 2 tables as a new table on the column 'category name' and display the results of that table.

[FBergamaschi]

Your question is unclear to me, please can you specify what you are asking

[MFelix]

Hi @deepuaits ,

For this you just need to have a dimension table that does the link between both table based on the image you present you should have a dimension table with the category name that has a one to many relationship with the Response Table Values and Cohort Table Values.

Then using the Category from the dimension table and the values from the facts you should be able to do what you need.