cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
creynolds
Helper V
Helper V

Relating Fields To A Single Table

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?

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @creynolds

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.

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

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors