cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Saidihn New Member
New Member

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 page in my original report, so I keep renaming/saving the origin report and keeping the Drillthrough "Details" page then creating a different report around it (sure there's a better way, but I'm still learning, so no big). So, I thought about using URL links to create a dynamic filter linking to a completely separate "Details" report that multiple reports can link to. The conditional column and linking worked, but the filtering did not. I've re-scratched a few times and took a few day breather to contemplate, but still no filtering.

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. Then I created a completely separate test report (just the Details" page) with no Drillthrough features, now ALL the projects try to show, depending on the visualization. I feel like I'm missing something super simple. Any ideas?

 

This is my custom column formula template:

 

https://reportURL?filter=TableName/ColumnName eq '"&TableName[ColumnName]&"'

 

There are no syntax errors detected with the actual column formula, either.

1 REPLY 1
v-xjiin-msft Super Contributor
Super Contributor

Re: dynamic url filter

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:

 

2.PNG

 

3.PNG

 

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

 

4.PNG

 

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.

 

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 254 members 2,431 guests
Please welcome our newest community members: