Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Date Picker / Calendar not available in Slicer when bind to Date parameter

Hi Team, 

 

There is no calendar icon or date picker in the Date Slicer when binding to the Date Parameter.

 

I follow the steps here but it didn't show it as well. 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#create-an... 

 

This is my date parameter.

PowerBIOrg_0-1691376840462.png

I bind it with 'Date' column.

PowerBIOrg_2-1691376943920.png

The slicer doesn't show any calendar/date picker. 

PowerBIOrg_3-1691377130236.png

 

 

I found similar issues, I follow all the steps but end up no solution that's working. 

https://community.fabric.microsoft.com/t5/Desktop/Date-Slicer-not-displaying-as-a-calendar/m-p/33654...

https://community.fabric.microsoft.com/t5/Desktop/Parameter-Binding/m-p/3355377 

https://community.fabric.microsoft.com/t5/Desktop/Date-Parameter-Binding/m-p/3354391 

 

 

Hope this issue can be resolved asap. Thank you.

 

Status: Needs Info
Comments
Anonymous
Not applicable

Hi @PowerBIOrg 

I tried to restore the scenario you mentioned but failed, can you provide your pbix file(remove sensitive info) for reference ?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

PowerBIOrg
Resolver II

Hi, Here is not allow to upload the pbix file. So I upload to my onedrive. Here is the link.

DateBind.pbix

Anonymous
Not applicable

Hi @PowerBIOrg 

Does your data schema meet the prerequisites for this feature?

vyetao1msft_0-1692260645007.png

 

Best Regards,
Community Support Team _ Ailsa Tao

PowerBIOrg
Resolver II

Hi @Anonymous 

 

My query run well so I assume that I have a valid M Query. Can you share a sample pbix file that show the binded Date slicer with calendar picker works from your side?

PowerBIOrg
Resolver II

Hi @Anonymous Any update?