Entire Table Columns Extraction with Slicer Selection

Hi helalm ,

Looking at you model and taking into account that you have several columns that may vary in number of columns have you tried making the unpivot of your tables and then make a append of the data?

That way you would have a single table with:

Form

subject ID

Attribute (column 1 to X)

Value

Then just use that table for your visualization using the attribute column has columns values.

For simplifing the treatement of the tables you have you can create a custom function on the query editor that makes the replication of the unpivot and merging alone and you don't have to upload all the tables in the model and merge them manually.

If you need help with that please tell me.

I used Anonymous  example to redo the file has refered.