Create a URL with Dynamic Filtering to Sub-Report

[lcasey]

Anyone,

I wanted to Post this URL I created for Filtering in case anyone else has issues.

The Below Link will goto reportsection2 of my report , and dynamically filter based on a field called ImageTag

Notice in my constructed URL I had to include the %20 to make it work as well as the %252

Step1 - Filter the report Manually to ensure its working

Step 2 - Copy the URL to NotePad

Step 3 - Create Column and Include the entire URL Up-To right before the fist ' used in the filter value
"https://app.powerbi.com/groups/me/reports/39d1cfaa-569f-46fd-9a52-d4188135af23/ReportSection2?filter..."

Step 4 - Use the & operator to add the ' +dynamicfield + the ending '

&"'" & Kwiktag[ImageTag] &"'"

Workflow = "https://app.powerbi.com/groups/me/reports/39d1cfaa-569f-46fd-9a52-d4188135af23/ReportSection2?filter..." &"'" & Kwiktag[ImageTag] &"'"

For Some reason it needs the %20 and the %252 in the url and I couldnt get this to work without including them.

[v-haibl-msft]

@lcasey

Thanks for sharing this. It seems to be a useful function.

Best Regards,

Herbert

[lcasey]

This Feature is very simular to SSRS reporting when you create an action Item on a field to open another report and Pass a parameter.