Need help on navigating to child report using web url by passing parameters

[azeenk]

Hello Guys,

I have a requirement where I need to create a column in the main report that links to a table visual in the child report. When you click on a particular row or record, the column's value should be filtered in the child report, and it should navigate to the child report. How can we achieve this?

Please provide some ideas or suggestions.

Thanks in advance !

Regards,

Hk

[v-venuppu]

Hi @azeenk ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @azeenk ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @azeenk ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rohit1991]

Hi @azeenk ,

You can do this by building a dynamic URL in a DAX measure or calculated column that combines the base URL of your child report with any field values you want to pass as filters. In your main report, add a column or measure like
ChildReportURL = "https://app.powerbi.com/groups/yourworkspace/reports/yourreport/ReportSection?filter=Table/Field eq '" & SELECTEDVALUE(Table[Field]) & "'"

If you need to pass multiple parameters, just add them using &filter=Table/Field2 eq 'value2' and so on. Once your URL is ready, add it to your table visual and use conditional formatting to turn it into a clickable Web URL. When someone clicks it, the child report opens filtered to the right value. Make sure the child report is shared with the same users and is set up to accept URL filters.

Also, if your field values have spaces or special characters, wrap them with URLENCODE() for safety. I’ve set this up in several reports and it works well as long as your field names and data types match between the reports. If you want the link to show up as a button instead, use a button visual and bind its action to the same DAX measure.

[azeenk]

Hi @rohit1991,

thanks for the update , i tried using the same approach, and using in table visual in the column and when i try clicking on it, if there is blank value its not showing any data in child report.

This isthe dax im using 

MainUrlPart =
VAR BaseURL = "https://app.powerbi.com/groups/702382c8-1b3f-434a-8a5d-5057e0bde7f3/reports/e9620c68-6719-48a8-9635-..."

VAR MinDate = qms_tij2x_precalculated_data[start_ts]
VAR StartDate = DATE(YEAR(MinDate), MONTH(MinDate), DAY(MinDate))
VAR EndDate = StartDate + 1

VAR DateFilter =
"qms_tij2x_stage_data/part_ts ge datetime'" & FORMAT(StartDate, "yyyy-MM-dd") & "T07:00:00'" &
" and qms_tij2x_stage_data/part_ts le datetime'" & FORMAT(EndDate, "yyyy-MM-dd") & "T06:59:59'"

-- Direct column reference filters
VAR SiteFilter = " and qms_tij2x_stage_data/site_nm eq '" & qms_tij2x_precalculated_data[site_nm] & "'"
VAR ZoneFilter = " and qms_tij2x_stage_data/workcenter_zone_nm eq '" & qms_tij2x_precalculated_data[workcenter_zone_nm] & "'"
VAR LineFilter = " and qms_tij2x_stage_data/line_nm eq '" & qms_tij2x_precalculated_data[line_nm] & "'"
VAR EquipFilter = " and qms_tij2x_stage_data/equip_nm eq '" & qms_tij2x_precalculated_data[equip_nm] & "'"
VAR GroupFilter = " and qms_tij2x_stage_data/group_nm eq '" & qms_tij2x_precalculated_data[group_nm] & "'"
VAR ProductFilter = " and qms_tij2x_stage_data/product_nm eq '" & qms_tij2x_precalculated_data[product_nm] & "'"
VAR PrefixFilter = " and qms_tij2x_stage_data/prefix_cd eq '" & qms_tij2x_precalculated_data[prefix_cd] & "'"
VAR ColorFilter = " and qms_tij2x_stage_data/color_cd eq '" & qms_tij2x_precalculated_data[color_cd] & "'"
VAR ParamFilter = " and qms_tij2x_stage_data/param_nm eq '" & qms_tij2x_precalculated_data[param_nm] & "'"
VAR MeasureToolFilter = " and qms_tij2x_stage_data/meas_tool_nm eq '" & qms_tij2x_precalculated_data[meas_tool_nm] & "'"

-- Final URL
RETURN
BaseURL &
DateFilter &
SiteFilter &
ZoneFilter &
LineFilter &
EquipFilter &
GroupFilter &
ProductFilter &
PrefixFilter &
ColorFilter &
ParamFilter &
MeasureToolFilter

[v-venuppu · Accepted solution]

Hi @azeenk ,

You can use the below updated DAX with all filter checks fully inlined:

MainUrlPart =
VAR BaseURL = "https://app.powerbi.com/groups/702382c8-1b3f-434a-8a5d-5057e0bde7f3/reports/e9620c68-6719-48a8-9635-..."

VAR MinDate = qms_tij2x_precalculated_data[start_ts]
VAR StartDate = DATE(YEAR(MinDate), MONTH(MinDate), DAY(MinDate))
VAR EndDate = StartDate + 1

VAR DateFilter =
"qms_tij2x_stage_data/part_ts ge datetime'" & FORMAT(StartDate, "yyyy-MM-dd") & "T07:00:00'" &
" and qms_tij2x_stage_data/part_ts le datetime'" & FORMAT(EndDate, "yyyy-MM-dd") & "T06:59:59'"

VAR SiteFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[site_nm]),
" and qms_tij2x_stage_data/site_nm eq '" & qms_tij2x_precalculated_data[site_nm] & "'",
BLANK()
)
VAR ZoneFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[workcenter_zone_nm]),
" and qms_tij2x_stage_data/workcenter_zone_nm eq '" & qms_tij2x_precalculated_data[workcenter_zone_nm] & "'",
BLANK()
)
VAR LineFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[line_nm]),
" and qms_tij2x_stage_data/line_nm eq '" & qms_tij2x_precalculated_data[line_nm] & "'",
BLANK()
)
VAR EquipFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[equip_nm]),
" and qms_tij2x_stage_data/equip_nm eq '" & qms_tij2x_precalculated_data[equip_nm] & "'",
BLANK()
)
VAR GroupFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[group_nm]),
" and qms_tij2x_stage_data/group_nm eq '" & qms_tij2x_precalculated_data[group_nm] & "'",
BLANK()
)
VAR ProductFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[product_nm]),
" and qms_tij2x_stage_data/product_nm eq '" & qms_tij2x_precalculated_data[product_nm] & "'",
BLANK()
)
VAR PrefixFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[prefix_cd]),
" and qms_tij2x_stage_data/prefix_cd eq '" & qms_tij2x_precalculated_data[prefix_cd] & "'",
BLANK()
)
VAR ColorFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[color_cd]),
" and qms_tij2x_stage_data/color_cd eq '" & qms_tij2x_precalculated_data[color_cd] & "'",
BLANK()
)
VAR ParamFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[param_nm]),
" and qms_tij2x_stage_data/param_nm eq '" & qms_tij2x_precalculated_data[param_nm] & "'",
BLANK()
)
VAR MeasureToolFilter =
IF(NOT ISBLANK(qms_tij2x_precalculated_data[meas_tool_nm]),
" and qms_tij2x_stage_data/meas_tool_nm eq '" & qms_tij2x_precalculated_data[meas_tool_nm] & "'",
BLANK()
)

RETURN
BaseURL &
DateFilter &
SiteFilter &
ZoneFilter &
LineFilter &
EquipFilter &
GroupFilter &
ProductFilter &
PrefixFilter &
ColorFilter &
ParamFilter &
MeasureToolFilter

Here are some final checklists:

• Put this measure into a column if you're showing it in a Table visual.
• Use "Conditional formatting - Web URL" to make it clickable.
• Ensure the child report is set up to accept filters via URL (parameterized with ?filter=... format).
• Test clicking links with and without blank values to confirm the filtering works correctly.

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! 

 Thank you.