Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I have been struggling to make a slicer which has date in a calendar format. I have two tables named StartDateTable and EndDateTable which have a Date Field. These Date Fields are bound to parameters StartTimeParameter and EndTimeParameter respectively and upon changing the slicers in the report it makes a live direct query with the new values of parameters.
The queries are all working fine, I just want a better visual representation, as it gets tedious to scroll the date list. Thanks for any help in this regard.
Solved! Go to Solution.
Thanks for the reply from @amitchandak , please allow me to provide another insight:
Hi @Anonymous ,
You might consider using a custom visual -- Date Picker.
Dynamic date slicer to filter multiple dates or date ranges, presets, calendar views, themes and customizations
This is an introduction to Date Picker viusal, I hope it helps you:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I personally prefer to use between slicer for Calendar slicer. You can choose from the calender and can use the range from the panel.
Thanks for the reply from @amitchandak , please allow me to provide another insight:
Hi @Anonymous ,
You might consider using a custom visual -- Date Picker.
Dynamic date slicer to filter multiple dates or date ranges, presets, calendar views, themes and customizations
This is an introduction to Date Picker viusal, I hope it helps you:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have used Date Picker but it didn't work. Please, understand that my queries are direct and it makes a direct query when I change the date. So, there is no notion of filtering, as I don't have the data available with me right away.