Forum Discussion
Binding Date parameters
that will only work for columns that are part of a Direct Query data source. Yours likely is in Import mode.
You need to bind the controlled field that is part of the direct query data source, not the controlling slicer column.
Hi Anonymous,
Thanks for reaching out to the Microsoft fabric community forum.
Other than the valuable point mentioned by lbendlin , Please check if the column data type is matching with the M parameter data type.
Additionally please check out this limitation of Dynamic M query parameter:
- If your parameter is the Date/Time data type, you need to cast it within the M query as DateTime.Date(<YourDateParameter>).
Source: 6th point Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
Yes Both the parameters are of same data type.
But column is a part of import mode.
I followed Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn and tried to implement the same.
As per this blog, table has been created using StartDateTable = CALENDAR (DATE(2016,1,1), DATE(2016,12,31)).
I implemented exactly whatever is mentioned in this blog. But unfortunately bind to parameter is not visible.
Is this a bug? Looking for quick resolution as I am stuck with some urgent implementation.
Thanks
Regards,
Pragya S
You need to bind the controlled field that is part of the direct query data source, not the controlling slicer column.