Forum Discussion
Pass date slicer value to dynamic M query parameter
Hello all,
I'm using SQL query in DirectQuery mode to get data from my SQL DB. I have a between clause in my query to fetch data between two dates. To allow the user to select this date from Power BI, I've created two dynamic M query parameter (start and end) & created two date table & binded them to the respective parametes. I've also created two list slicers for the dates and when user selects a date, the query runs with the given date and the table updates fine.
The issue is the date range I need is about 20 years and I don't want the user to scroll through the dropdown list to find a date. Instead I need a calendar popup where the user can select the date. I tried setting the slicer style to between but not sure how to pass the two values in the slicer to the parameters. Any help will be much appreciated. Thanks!