Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help with Drillthrough Link – Child Report

  Hi Team, I'm currently working on a Power BI report that includes a drillthrough feature to navigate from a main report to a child report. I'm using the following DAX expression to generate the d...
  • v-achippa's avatar
    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