Pick fields

[aspitalnick]

I have a maser table with unique identiers and multiple data tables connected to it one to many. I'm trying to figure out how to set it so that I have a table and can choose which columns from multiple tables show (or don't show), potentially showing data from multiple tables at the same time. When I try filed parameters I can click on multiple columns dfor one test in the filter and it will show, until I chose a column from a second test and then the tables goes blank. Here is a link to dummy data https://drive.google.com/file/d/18OnWlRlzCNcpicLEzrDKvk27Y4C-Rjmi/view?usp=drive_link

Both test tables have a student id that links to a master student ID list. 

[Anonymous · Accepted solution]

Hi @aspitalnick 

All you need to do is create a field parameter for each table.

Then put all the fields on the same table.

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @aspitalnick 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

[aspitalnick]

I would like the field parameter to look just like the table below it, but I'd like to be able to click on or off columns.

https://drive.google.com/file/d/18OnWlRlzCNcpicLEzrDKvk27Y4C-Rjmi/view?usp=drive_link