Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating Slicer for a parameter

Hi All,

 

I have a doubt if its possible to create a slicer or a filter for the parameter created.

 

I have created two parameters to call my Store procedure on the SQL and it is working fine.

 

There is no date column in my dataset, is there any way I can create a date slicer using parameters so that a user can select the dates to filter the data ( Its ok if that will call the procedure on SQL )

 

Query used:

 

 

Regards,

Himanshu

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      As I can check we can use these dynamic parameters in M language when we are using Direct query but I'm using Import method.

       

      Any suggestions for Import method?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        Refering from the blog:

        With Dynamic M Query Parameters, model authors have more control over how filter selections get incorporated into DirectQuery source queries.

        I think Dynamic M query parameters in Power BI Desktop (preview) should only support for direct query data source.

        Your demand is a good idea, while it is not supported to implement in Power BI currently.
        You can submit a new idea to improve the Power BI.
        It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

        Best Regards,
        Rico Zhou

         

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