Forum Discussion

deerzzxdell's avatar
deerzzxdell
Frequent Visitor
1 year ago

Create filter in the report to dynamically filter the dataflow parameter

Hi community,

 

In my Power BI I use 2 data flow for production and dev environment and I use list parameter to change between these 2 data sources. To enhance this for the developer team, I would like to know if it is possible to create a filter in the report view to filter these 2 data parameters dynamically without entering power query.

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi deerzzxdell 

    That is not currently possible.  M affects the data model but it isn't the other way around. You can't pass on, say, a slicer selection, to the query.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi deerzzxdell ,

    Dynamic M query parameters can be bound to fields, thus allowing the value of the field to be passed into the parameter.

    This means that the choice of slicer affects the parameter values.

    Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

    However, after testing, this only works for native queries, not for data source switching.

    When applying a parameter to a data source path, the default value of the parameter is always used.
    Dynamically passed field values do not change the default value of the parameter unless changed manually.

    So, as danextian said, this is currently not possible.


    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.