Forum Discussion

kaushikhalvadia's avatar
kaushikhalvadia
Regular Visitor
3 years ago

How to use slicer(between dates types) with multiple column

Hi, I am a beginner and learning Powerbi. I'm creating this is 3rd report 

 

Below is my SQL query for the report which gives me the expected and accurate output. 

Now, I want to pass the StartDate and EndDate values from the slicer(Between types)

 

Can someone please tell me how to achieve this?

 

PS. I can pass and fetch date columns/parameters in any format. Currently, I have passed the dates as varchar.

Thanks in advance for your help and guidance

 

 

General Comment
Interesting Links
Need Help
Tips and Tricks

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi kaushikhalvadia ,

    Sorry I'm not very clear about your description, would you like to clerify it with an example?

    Best Regards,
    Community Support Team _ kalyj

    • kaushikhalvadia's avatar
      kaushikhalvadia
      Regular Visitor
      3 years ago

      Hi v-yanjiang-msft 

       

      Sure. I'm trying to explain.

       

      I want the output to be displayed in a report in table format.

      The report will have a slicer as below where the user can select a date range.

      Based on the user-selected date range in the slicer, the below SQL query will run and display info in tabular format. I want to know how to pass the user's selected date range value from the slicer to the query.

       

      Thanks for the help!