Query date parameters linked to a filter

[verocorrea93]

Can anyone help me set up query date parameters that are connected to a filter in a report?

I have created two query parameters: StartDate and EndDate. I have used those in a query, where I'm getting a table from BigQuery and filtering so that the values in columns session_start_date are smaller than the EndDate parameter, and the values for session_end_date are larger than the StartEnd parameter. 

I want to be able to user filters in my report to dynamically change the values for StartDate and EndDate: however, when I add a slicer I can only see the parameters' current value, and not all the values it cna take on.

M query: 

 Parameters:

 

Parameter filter:

Why can I only see June 1st on the slicer instead of all the dates on I had on the list when setting up the query parameter?

If you have any other ideas of how to dynamically query data using filters/slicers let me know 🙂

Thank you for your help!

[amitchandak · Accepted solution]

@verocorrea93 , That we can use in Direct Query Table on supported sources

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[verocorrea93]

@amitchandak thank you for the helpful information. I followed the tutorial, and when I bind the field in the table to the parameter, it breaks. I get the following error:

Do you know why that may be? 

[verocorrea93]

Thank you @amitchandak 🙂