Forum Discussion
Pick fields
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.
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.
3 Replies
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.
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
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.
