Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |