Forum Discussion
Dynamically join tables with filters values from Slicer
I am trying to have a dynmaic table that is the union of the other tables that have relationships and slicers.
Systems are linked to specific subsystems which are linked to specific components. Selecting a specific system via slicer will filter the subsystem and components as expected in their individual timing charts. I have individual timing charts for all there which work as intended but when I utilize a Power Querry Append or DAX Union to create a single timing table and chart I don't get the slicer filtering to carry over. Since a table can only have one relationship I cannot link all the relationships to make the slicers vwork directly.
I have file that demostrates the issue but not sure how to share it.
5 Replies
v-jiascu-msftMicrosoft Employee
Hi ams123,
1. You can upload the file to the cloud drive like OneDrive, GoogleDrive and then share the download link here.
2. The calculated table can't respond to the slicers.
3. What's the expected result?
Best Regards,
Dale1) Here is my demo file
https://1drv.ms/u/s!AlfwErB6m5JThTQzvqKm2LDKuMxg
Is there another way to build the table so it will be the combination of the sliced tables.
- v-jiascu-msft
Hi ams123,
What's the expected result?
Would like to integrate the three tables into one? Maybe the fields of the slicers should be from the One table [Timing].
Best Regards,
Dale
