Forum Discussion
Parameter/Bind variables based on Date Calendar Input
Hi Anonymous
It seems you are using the Dynamic M query parameter feature. Please refer to the following document to check if your settings have hit one or multiple limitations or unsupported scenarios when using this feature.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
At present it seems your table names have hit below limitation:
- Table names can't contain spaces or special characters.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
I confirm there is no space in the table name.
Start_date and End_date are 2 calendar DAX tables and date columns are linked to parameters. But I want to use 1 calendar input slicer to selecf dates between and pass the range as parameter, is it possible?
Hi Anonymous
I'm afraid this is not supported as it would hit another limitation:
- A single parameter can't be bound to multiple fields nor vice-versa.
In a date slicer, it only has one date field, which cannot be bound to two paramters.
Best regards,
Jing
Is there any other workaround? I also tried to create a calculated column based on date selection i.e. FIRSTDATE() and LASTDATE() and linked it with variable but had no luck, would you know if I can create a date_table2 that will hold MAX and MIN dates of date_Table1 , when a date range is selected in date_Table1, table2 Max and Min columns will be filtered and hold the start and end range values?