Forum Discussion

michaelb's avatar
michaelb
Regular Visitor
5 years ago

Filtering Based on a Parameter

Is it possible at all to filter a report based on a parameter that can be changed, or at least set at load time for an embedded report?   We are using embedded reports and need to be able to pass a...
Data Protection
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi michaelb,

 

In October it was relaese the Dynamic M Query Parameters that you can associate a query parameter to a slicer in your report maybe that will help to solve your problem:

 

https://powerbi.microsoft.com/en-us/blog/power-bi-october-2020-feature-summary/#_Toc51665421

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#:~:text=Enabling%20Dynamic%20M%20query%20parameters,-Dynamic%20M%20Query&text=Select%20File%20%3E%20Options%20and%20settings,the%20change%20to%20be%20enabled.

 

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

michaelb's avatar
michaelb
Regular Visitor
5 years ago

Hi MFelix,

Unfortunately this solution will not work for us as we are using an OData feed, not a Direct Query, so the parameter binding feature is not available.

Additionally, we need to be able to set the parameter values via the JavaScript API. The values need to be locked and hidden from the user which currently requires us to iterate over all visuals and update the filters accordingly.