Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Binding Date parameters

Hi,   I am trying to bind date parameter, but Unfortunately bind to parameter option is not visible. Following the reference document - https://learn.microsoft.com/en-us/power-bi/connect-data/desk...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    that will only work for columns that are part of a Direct Query data source. Yours likely is in Import mode.

  • lbendlin's avatar
    lbendlin
    1 year ago

    You need to bind the controlled field that is part of the direct query data source, not the controlling slicer column.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Yes Mine is import mode and I have created Calendar table as mentioned in the document Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn. And as per steps mentioned I can see this StartDate is binded to Date Parameter.

StartDateTable = CALENDAR (DATE(2016,1,1), DATE(2016,12,31))

 

I followed the same steps.Please let me know if we can follow this documentation or if anything is wrong over there. 

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi Anonymous ,

At the moment, there are no known issues with the documentation, and no other users have reported similar concerns in the forum. Please try replicating the same steps in a new PBIX file to see if you're able to bind the parameter successfully.

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