Relating Fields To A Single Table

Anonymous · ‎01-20-2019

I have one single table driving 8 tables on a dashboard. I want to relate each of these tables together so when a value is selected in one table, the other tables adjust accordingly. How can I do this without duplicating this single table 8 times plus creating relationships among the 8 tables?

v-lili6-msft · ‎01-20-2019

hi, @Anonymous

Are the eight tables related to each other?

For your requirement (when a value is selected in one table, the other tables adjust accordingly),

you need to create the relationships between them, If they have relationships with each other, they could create the relationships

between each other, otherwise, they should create the relationship with the single tale.

If it is not your case, please share a simple sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎02-06-2019

I have attached the source files for review. Again, this PBIX file is a measure of survey results. Each visual is pulling from the same Excel file. Each visual is unique by showing the results for a specific question asked. All visuals are displaying the top count and %. I would have thought regardless of which table I choose, when clicking on a value, each of the other tables adjust showing the results of what was selected. The only visual that works consistently is the "Plan Architecture Name".

H2 POC V4 PBIX

H2 POC V4 XLS