Pass filters in URL
It would be great if we can pass filters in the url of the dashboard, which will filter the reports based on various parameters e.g. current fiscal period, geography, person's role, department etc.
Thanks to everyone who participated in the filter survey last year and for leaving detailed comments below in the meantime as well.
We used your feedback to prioritize and release two enhancements to our filtering:
1. In June, we released the ability to share report filters with others. Behind the scenes, this creates a bookmark with the current slicer/filter state and share a URL containing that bookmark ID. You can use that URL as you wish – in portals, your own emails, anywhere!
2. In August, we expanded support for URL filters on reports, by supporting additional data types (datetime), additional operators beyond equals (greater than or equals, greater than, less than or equals, less than), and the ‘in’ operator to allow filtering on multiple values easily. See more details at https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/
We hope these improvements have been helpful to you. If this wasn’t enough and you still want other functionality, please vote on one of these ideas:
- For filters on dashboards, which would pave the way for filtering through the URL: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6674820-global-filter-in-dashboards
- For personal bookmarks: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31788253-personalized-bookmarks
I just want to be able to set the "parameter" values in the url
We can filter dashboards with URL parameters with ?filter
But I created a parameter on the dashboards and want to set the value of that parameter in the URL with ?parametername=parametervalue
I really don't understand why this isn't implemented. Having to set the value of that parameterin the report settings doesn't make sense?
Best way is to pass parameters to bookmark !
hi great feature if that include bookmark in url paramter filter.
Mike Kostuch commented
It would be great if we can pass filters in the url of the dashboard, which will filter the reports based on various parameters e.g. current fiscal period, geography, person's role, department etc for Power BI Embedded as well as Power BI Service.
Mark Eckert commented
Any update on this 'Pass filter to URL' issue
Arthur van Rijn commented
Hi Sirui Sun, please provide an update on this 'Pass filter in URL' item. It's in the planning for 18 months now. Is there a roadmap for this embedded feature ? Hope so, we have got many votes ! Regards from Amsterdam, Arthur
+1, this is a key feature to make PowerBI reports integrated into automation workflow.
If planning is underway for this feature it would also be beneficial to have url filters that can be encrypted to ensure security around sensitive or customer reporting.
This is very useful in SSRS so would be great to have in PowerBI also for the same reasons
Ryan R commented
It would be great if this worked on reports embedded through iframe.
Any News? @sirui_Sun?
Atak, how do you make the project work?
use this C. visual
This idea would also drive home the progression from SSRS into PowerBI.
Tyler Harrell commented
And pass the filters as you export out to Power Point file.
Marc LaFleur commented
This would be extremely useful, particularly in semi-embedded scenarios such as pinning as a Tab in Microsoft Teams. The ability to pin a dashboard with preset filters would remove the current need to publish multiple copies of the same report with nothing more than different filter values applied.
Ryan R commented
I love the subscribe to report feature. When you click on the subscribe button, it would be great to be able to subscribe to the report with the currently selected filters that were passed in the URL.
Alex Hauge commented
Being able to link to other pre-filtered reports would be immensely helpful. We are currently doing this with the one filter that is currently supported, but having more would give much more functionality to this concept.
Yar Dost commented
I second this as well.
"Anonymous commented · April 03, 2017 23:54 · Flag as inappropriate
It would be great if it was possible to design a Power BI report, with for example a matrix or table that contains elements that were in themselves links to another Power BI report that is filtered for that particular value. For example if we created a table of countries, where each country name is a link that opens another report filtered for that particular country. "
It would be great if it was possible to design a Power BI report, with for example a matrix or table that contains elements that were in themselves links to another Power BI report that is filtered for that particular value. For example if we created a table of countries, where each country name is a link that opens another report filtered for that particular country.