Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Parameter Binding

Hi, Parameter binding to columns in a table is working fine but only one question about it is when I am having the parameter (date parameter) binding to date column X , pulling this X date column as...
Need Help
  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi Anonymous ,

     

    Make sure the data type is Date or Date/time, if not, you won't be able to preview it as a calendar inside the slicer

     

    If it doesn't solve your question, please provide a sample file or a screenshot to solve it faster.

     

    Best Regards,

    Gallen Luo

v-jialluo-msft's avatar
v-jialluo-msft
Community Support
3 years ago

Hi Anonymous ,

 

Make sure the data type is Date or Date/time, if not, you won't be able to preview it as a calendar inside the slicer

 

If it doesn't solve your question, please provide a sample file or a screenshot to solve it faster.

 

Best Regards,

Gallen Luo

PowerBIOrg's avatar
PowerBIOrg
Resolver II
3 years ago

Hi v-jialluo-msft 

 

I binded my date as parameter, it didn't have calender/search selections in my report. 

 

 

Not sure what I missed out. 

 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You are missing the binding part. That is done in the data model view. It requires your data source to be in Direct Query Mode.

    • PowerBIOrg's avatar
      PowerBIOrg
      Resolver II
      3 years ago

      Hi, I bind the date as following. 

      Which data source need to be in Direct Query mode? My display data already in Direct Query mode.

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Your Date table is in import mode. That won't work with dynamic query parameters.