Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
dkernen
Resolver II
Resolver II

Paginated Report - Parent/Child Datasets

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

3 REPLIES 3
AbhiSSRS
Solution Sage
Solution Sage

As much I understand this case it would need a subreport implementation. I have done one for the Paginated visual so that may help :

 https://www.linkedin.com/pulse/power-bi-multiselect-paginated-visual-abhinav-singh/?trackingId=iVMEo...

v-henryk-mstf
Community Support
Community Support

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.