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?
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".