Forum Discussion
Help with Drillthrough Link – Child Report
- 1 year ago
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community.
The issue is likely caused by missing URL encoding or case sensitivity in your drillthrough URL filters:
- When you drill through using group_nm = NENS or HCI, the generated URL might break if the value contains special characters like spaces or if it is not encoded properly. This cause the child report may receive an invalid or incomplete filter, leading to blank visuals.
- Also please ensure that the group_nm field is included in the Drillthrough filters section of your child report. This is needed for the drillthrough to work correctly, as it ensures that the necessary filter is passed from the main report.
- One quick fix is like wrap all the “SELECTEDVALUE(...)” expressions with ENCODEURL() in your DAX for example like
ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[group_nm]))
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi @azeenk,
We wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @azeenk,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa