Help with Drillthrough Link – Child Report

[azeenk]

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 drillthrough URL:

DAX

MainUrlPart =
VAR BaseURL = "https://app.powerbi.com/groups/702382c8-1b3f-434a-8a5d-5057e0bde7f3/reports/e9620c68-6719-48a8-9635-..."
VAR DateFilter =
CONCATENATE(
"qms_tij2x_precalculated_data/start_ts ge datetime'",
CONCATENATE(
FORMAT(MIN(qms_tij2x_precalculated_data[start_ts]), "yyyy-MM-dd"),
"T00:00:00' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/part_ts lt datetime'",
CONCATENATE(
FORMAT(
DATE(
YEAR(MAX(qms_tij2x_precalculated_data[start_ts])),
MONTH(MAX(qms_tij2x_precalculated_data[start_ts])),
DAY(MAX(qms_tij2x_precalculated_data[start_ts])) + 1
),
"yyyy-MM-dd"
),
"T00:00:00' "
)
)
VAR Filters =
CONCATENATE(
"and qms_tij2x_precalculated_data/group_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[group_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/param_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[param_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/line_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[line_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/product_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[product_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/prefix_cd eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[prefix_cd]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/workcenter_zone_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[workcenter_zone_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/site_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[site_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/color_cd eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[color_cd]),
"' "
)
)
VAR FullURL = CONCATENATE(BaseURL, CONCATENATE(DateFilter, Filters))

RETURN FullURL

There is a column called group_name that contains values like PA, NENS, and HCI.
In the main report, I have applied a filter to show only PA. When I click and navigate to the child report for PA, it works fine.

However, when I change the selection to NENS or HCI in the main report and then click to drill through, the child report opens but shows blank visuals – even though data exists for those groups.

I have confirmed that the group_name field is the same in both the main and child report.
Can someone help me identify what might be causing the child report to go blank for NENS and HCI?

Thanks in advance!

Regards,

Hk

[v-kathullac]

Hi @azeenk ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @azeenk ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @azeenk ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac · Accepted solution]

Hi @azeenk ,

Thank you for reaching out to Microsoft Fabric Community Forum.

Can you try this below Dax i think it will solve your issue i have used ENCODEURL Function in the updated dax formula.

MainUrlPart =
VAR BaseURL = "https://app.powerbi.com/groups/702382c8-1b3f-434a-8a5d-5057e0bde7f3/reports/e9620c68-6719-48a8-9635-..."
VAR DateFilter =
"qms_tij2x_precalculated_data/start_ts ge datetime'" &
FORMAT(MIN(qms_tij2x_precalculated_data[start_ts]), "yyyy-MM-dd") & "T00:00:00' and " &
"qms_tij2x_precalculated_data/part_ts lt datetime'" &
FORMAT(
DATE(
YEAR(MAX(qms_tij2x_precalculated_data[start_ts])),
MONTH(MAX(qms_tij2x_precalculated_data[start_ts])),
DAY(MAX(qms_tij2x_precalculated_data[start_ts])) + 1
),
"yyyy-MM-dd"
) & "T00:00:00' and "

VAR Filters =
"qms_tij2x_precalculated_data/group_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[group_nm])) & "' and " &
"qms_tij2x_precalculated_data/param_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[param_nm])) & "' and " &
"qms_tij2x_precalculated_data/line_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[line_nm])) & "' and " &
"qms_tij2x_precalculated_data/product_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[product_nm])) & "' and " &
"qms_tij2x_precalculated_data/prefix_cd eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[prefix_cd])) & "' and " &
"qms_tij2x_precalculated_data/workcenter_zone_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[workcenter_zone_nm])) & "' and " &
"qms_tij2x_precalculated_data/site_nm eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[site_nm])) & "' and " &
"qms_tij2x_precalculated_data/color_cd eq '" & ENCODEURL(SELECTEDVALUE(qms_tij2x_precalculated_data[color_cd])) & "'"

VAR FullURL = BaseURL & DateFilter & Filters

RETURN FullURL

Regards,

Chaithanya.

[azeenk]

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 drillthrough URL:

DAX

MainUrlPart =
VAR BaseURL = "https://app.powerbi.com/groups/702382c8-1b3f-434a-8a5d-5057e0bde7f3/reports/e9620c68-6719-48a8-9635-..."
VAR DateFilter =
CONCATENATE(
"qms_tij2x_precalculated_data/start_ts ge datetime'",
CONCATENATE(
FORMAT(MIN(qms_tij2x_precalculated_data[start_ts]), "yyyy-MM-dd"),
"T00:00:00' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/part_ts lt datetime'",
CONCATENATE(
FORMAT(
DATE(
YEAR(MAX(qms_tij2x_precalculated_data[start_ts])),
MONTH(MAX(qms_tij2x_precalculated_data[start_ts])),
DAY(MAX(qms_tij2x_precalculated_data[start_ts])) + 1
),
"yyyy-MM-dd"
),
"T00:00:00' "
)
)
VAR Filters =
CONCATENATE(
"and qms_tij2x_precalculated_data/group_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[group_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/param_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[param_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/line_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[line_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/product_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[product_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/prefix_cd eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[prefix_cd]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/workcenter_zone_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[workcenter_zone_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/site_nm eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[site_nm]),
"' "
)
) &
CONCATENATE(
"and qms_tij2x_precalculated_data/color_cd eq '",
CONCATENATE(
SELECTEDVALUE(qms_tij2x_precalculated_data[color_cd]),
"' "
)
)
VAR FullURL = CONCATENATE(BaseURL, CONCATENATE(DateFilter, Filters))

RETURN FullURL

There is a column called group_name that contains values like PA, NENS, and HCI.
In the main report, I have applied a filter to show only PA. When I click and navigate to the child report for PA, it works fine.

However, when I change the selection to NENS or HCI in the main report and then click to drill through, the child report opens but shows blank visuals – even though data exists for those groups.

I have confirmed that the group_name field is the same in both the main and child report.
Can someone help me identify what might be causing the child report to go blank for NENS and HCI?

Thanks in advance!

Regards,

Hk