March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
3 |