cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
imous
Frequent Visitor

URL Filter not working

I haven't been able to get the Filtered URL feature on my dashboard to work. I believe I followed all the steps. While the column to be filtered on (PartID) contained numbers, I changed it into a Text format.PowerBIFiltersData.PNG

 

I published this report, made a dashboard of the page I want and tried to access that dashboard with filters using the following URL:

 

https://app.powerbi.com/groups//dashboards/[dashboard code]?filter=Combined/PartID eq '1'

 

Using this URL (which translates to https://app.powerbi.com/groups//dashboards/[dashboard code]?filter=Combined%2FPartID%20eq%20%271%27 ) does open the dashboard, but seemingly without any filtering applied. 

 

PowerBIFiltersGraph.PNG

 

The linegraph plots temperature vs time with PartID used as Legend. I expect to see only one line, from PartID=1, but they;re all shown. The Maximum and Average temperature are also based on data from all PartID's.

 

If someone could tell me what I'm missing here, I'd greatly appreciate it.

1 ACCEPTED SOLUTION
v-huizhn-msft
Microsoft
Microsoft

Hi @imous,

If you want to filter the report in dashport using URL, you need to get the URL of your report instead of dashboard, like the following URL. A dashbord includes many reports, there is each URL per report.

https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3

Then add the filter string: ?filter=Table/ColumnName eq 'value'.  For example:?filter=Store/Territory eq 'NC', you will get: 

https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3?filter... eq 'NC'

Finally add a tile in dashbord, enter the Custom URL of a tile as follows! When you select the tile, it will show the filtered report.

2.PNG

Reference: https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/.

Best Regards,
Angelia

 

View solution in original post

3 REPLIES 3
v-huizhn-msft
Microsoft
Microsoft

Hi @imous,

If you want to filter the report in dashport using URL, you need to get the URL of your report instead of dashboard, like the following URL. A dashbord includes many reports, there is each URL per report.

https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3

Then add the filter string: ?filter=Table/ColumnName eq 'value'.  For example:?filter=Store/Territory eq 'NC', you will get: 

https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3?filter... eq 'NC'

Finally add a tile in dashbord, enter the Custom URL of a tile as follows! When you select the tile, it will show the filtered report.

2.PNG

Reference: https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/.

Best Regards,
Angelia

 

View solution in original post

Hi @v-huizhn-msft ,

 

We are deploying URL filters in Report A that are linking to various deployed apps.  I am usins this syntax as recommended by the Microsoft documentation - app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter=Table/Field eq 'value&'ctid=ctid

 

This works fine in Chrome-based browsers, but it has limited success in Edge.  In fact, most of the time if fails in Edge and reroutes to app.powerbi.com (showing a blank page in the Power BI environment).  

 

Do you any idea why this may be?  Or recommendations to solve?

 

Thank you!

 

Jake

Thank you very much. I was working from the instructions in that link, but completely missed it had to link to a report. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors