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

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

lbendlin's avatar
lbendlin
Super User
1 year ago

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