Forum Discussion

Saidihn's avatar
Saidihn
New Member
8 years ago

dynamic url filter

I recently built a report utilizing the Drillthrough feature for a "Details" page, which is outstanding, but now I have other high level stakeholder reports that want to Drillthrough to the same pag...
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Saidihn,

 

=>At first I was using the URL of the Drillthrough "Details" page from the original report (test version), but only the first row project information would show.

 

In your scenario, the original report is containing Main page and Details page and you have made Drillthrough in Main page to drill through to Details page. So now, you are using the URL with filters inside to open the Details page directly. However, it only displays one row in the report. Right?

 

If I misunderstand your issue, please feel free to correct me. First I have made a simple test like below, and everything works fine. Please refer:

 

Main and Details page:

 

 

 

Then use URL to open Details page: " https://reporturl?filter=Table2/Item eq 'A' "

 

 

Since as you said that it only returns one row. Please verify that if you have selected any filters in Drillthrough filters before you publish your report to Power BI Service.

 

And if it is possible, please share us your original pbix file with One Drive or Google Drive or some screenshots about your situation.

 

Thanks,
Xi Jin.