Forum Discussion
How to show two different table values in Single Table visual
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
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.
7 Replies
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.
Your question is unclear to me, please can you specify what you are asking
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.
