Forum Discussion
Advocate IIDate Picker in slicer
What is I observe is, if the column is 'Bind to Parameter' you only see Vertical List, Tile and Dropdown.
But when it is NOT binded to Parameter you see Between, before, After Relative date and Time.
The Parameter 'Param_StartDate' is defiend as 'Date' data type.
the column EMPL.BIRTH_DT is a 'Date' data type in the database.
And the where clause in the M code reads as
"where EMPL.BIRTH_DT = ' "&Date.ToText(Date.From(Param_StartDate),"yyyy-MM-dd")&" '
Hi rnola16 ,
Thank you for sharing the details and your valuable observations about date slicers in Power BI with dynamic M query parameters.
You're right, When a field like Date_Col is linked to a parameter such as Param_StartDate, the slicer options become limited. You can only use basic types like Dropdown, Tile, or Vertical List, while advanced options like Between, Before, After, or Relative Date/Time are no longer available.
This behavior is intentional and is a known limitation of dynamic M query parameters in Power BI, as mentioned in the official Microsoft documentation.
Link:Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Also, thank you kushanNa , for referencing the helpful video and prior blog post which demonstrated this limitation and offered practical guidance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserIf you're trying to do the same thing this developer is doing in here https://www.youtube.com/watch?v=pXU_SpiBWUA&t=1291s&ab_channel=DataPlatformCentral
then When you bind the column to a parameter, the date slicer will change into a dropdown and will no longer give you the option to use it as a regular calendar-style date picker. note that this video is 3 years old
Advocate IIYes, been through this from Data Platform. I believe its a flaw in the application to not let Between, Relative Date/time, Before , After when the field itself is set to 'Date'. Microsoft should provide its own visual like 'Date Picker' in its visual List.
- rnola16
Alternatively, created a dynamic date prompts where user can enter dates in the field along with other parameters and run it live. Avoids the hassle of scrolling down for the dates.
V-yubandi-msftCommunity Support
Hi rnola16 ,
That’s an good alternative using a dynamic date input prompt is an effective way to address the slicer limitations caused by parameter binding.
It is certainly more user-friendly for managing large date ranges and provides report consumers with better control over their input.
Thank you for sharing your work around. If your issue is resolved, please consider marking it as the Accepted solution, as it could greatly assist others facing the same challenge.
Regards,
Yugandhar.