Forum Discussion
Best visual for longitudinal repeating instruments data
Hi JoeCrozier ,
Please add Index column for each group in Power Query Editor.
Create Row Number for Each Group in Power BI using Power Query
Then select the rows with index = 0 for the first table.
And select the rows with index <> 0 for the second table.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Update: I've tried putting a filter on the top visual, to filter specifically to protocol_information, but because the other visual is linked to it, if that top visual is filtered, nothing will show up in the bottom. I also understand why its saying "First" and can change that, but its still not the best visual for it.
I've thought one way to do it might be to "split" the raw data into two tables (one with basic info from the top visual and another with comments from the bottom visual) and then merge them back together on protocol title. Any thoughts are appreciated.
Hi JoeCrozier ,
Please add Index column for each group in Power Query Editor.
Create Row Number for Each Group in Power BI using Power Query
Then select the rows with index = 0 for the first table.
And select the rows with index <> 0 for the second table.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.