Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I have a powerbi report which has Team and Subteam slicers. I want to get reports for specific teams. When I pass specific team name in url using below filter url, it does not change the value in the team slicer and hence I am not getting the required report.
?filter=Team/teamname eq 'team1'
I don't want users to select the specific team but the teamname value given in the url should automatically get selected in the slicer and load the report accordingly. Is it possible and How do I do it?
Solved! Go to Solution.
Hi @Anonymous
The URL filter works like a report-level filter on all pages in the report. It will be applied to all visuals in the report, including your Team slicer. But it cannot select the option on your behalf. It cannot do a 'Select' operation.
If your URL filter doesn't work on the report, check whether the table name and column name in the URL are completely consistent with the names in your model as Table and Field names are case-sensitive.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
The URL filter works like a report-level filter on all pages in the report. It will be applied to all visuals in the report, including your Team slicer. But it cannot select the option on your behalf. It cannot do a 'Select' operation.
If your URL filter doesn't work on the report, check whether the table name and column name in the URL are completely consistent with the names in your model as Table and Field names are case-sensitive.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |