Forum Discussion
Query date parameters linked to a filter
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!
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
3 Replies
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
Thank you amitchandak 🙂
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?
