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 ,
To achieve navigation from a main report to a child report in Power BI by passing parameters through a web URL, you can create a dynamic URL in a new column or measure that embeds the necessary filters. You would use the base URL of the child report and append query string parameters corresponding to the fields you want to filter. 

In Power BI, you can construct this URL using DAX by concatenating the fixed part of the child report’s URL with dynamic field values from the selected row. Once the URL is built, you can use a table visual to display it as a clickable link or use a button with an action set to "Web URL" linked to your DAX expression.

When users click on a row, they will be navigated to the child report, with the appropriate filters applied based on the selected record. It’s important to ensure that the child report is configured to accept URL parameters for filtering so that the navigation works smoothly.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar.

[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.