Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have three datasets: ReferralCase table ("parent"), SurveyResponse table ("child"), and ReferralsInDateRange (taken from a slicer in Desktop). They are all created in DAX from Desktop, but then I modifed them for the multi-select.
The parameters I have set are a start date and and end date, from which the Referrals parameter populates based on the referrals in range. Then the user can multi-select which referrals to select.
I have the initial header section working fine with the multi-select, but I don't know how to get the detail information from the SurveyResponses to populate right after each respective group (referral). The tutorials I have found online all show data only from a single dataset. I would like to know how to utilize the key value (Referral_ID) and pass the respective parameter value to the detail table. Then each referral selected would show the referral/case detail followed by the zero, 1 or more responses on one page, then the next referral with its responses, etc.
Do I use a list or a subreport? How do I tell the list/subreport which Referral's survey responses to pull? Do you have a step-by-step resource to walk me through the steps? I have attached my RDL. I am really stumped. Thank you so very much!
https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/ETeHifJn0idOmwsIAl1ShbMBzw6N3qlbcRXQq...
@multi-select, @paginatedreport, @parentchild
As much I understand this case it would need a subreport implementation. I have done one for the Paginated visual so that may help :
Hi @dkernen ,
It is not very clear, whether you can further clarify your needs. Such as screenshots of expected results, etc. Looking forward to your reply.
Best Regards,
Henry
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
14 | |
5 | |
5 | |
4 | |
4 |